Hi, Would you mind putting a FK constraint on itemnumber in aqorders_items (with cascaded delete) ? Please feel free to join the discussion on report http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11617 Thanks, Marcel