Hi Adam,

>> Open up database work bench and try and manually insert a record into
>> BUS_KEY_FEAT.

Did that - still got the same problem

>> We really don't have enough information to trouble
>> shoot for you, and it is difficult to grasp what you are trying
>> without seeing some data in there.

What information do you need ? I can send you the DB if required

>> What are your triggers doing to your FK's?

There are no triggers on the table being inserted to

>> Is the foreign key referring to the tables and fields that you think
>> it is? (dont answer yes, check it again)

yes

>> Is there any other transaction that may have deleted the parent
>> record that you can not see yet?

NO

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results