Expert: Rob Henderson - 2/11/2005

Question
Ron,

Thanks for all your help on the previous database! I think my relational structure is flawed. I'm going to get back into it ASAP, but until then I've got this database...

"The Microsoft Jet database engine cannot find a record in the table
'tblOrgs' with key matching fields(s) 'tblDocs_fldOrgId.'

This is the error that pops up when I try to create a record... I've tried
everything countless times, but I can't fix it! Please help! The tiny
database is zipped and ready to send. I didn't want to send you a new file without checking with you first.

I've got a main form with two combo boxes, some text boxes, and a datasheet
view of a subform on it. If I enter stuff into the combo boxes and text
boxes on the main form first and then go to the datasheet, I can almost
create a new record, but the error message pops up.

If I populate the datasheet first, the error pops up as soon as I click one
of the combo boxes.

Help!  

Answer
Hi

This sounds like your relationships have ref integrity and are preventing the update of the table.

I.e. With referential integrity a one to many means you you must provide the one side before the many

Does that make sense?

I would welcome the zip file normally but I'm away for the weekend and don't have time to investigate for you.

Try the relationship types and see what happens.

rob