There are several column in aqbudgets that should have FK constraints on them: budget_branchcode => branches.branchcode budget_owner_id => borrowers.borrowernumber sort1_authcat sort2_authcat => authorised_value_categories.category_name