About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Using MS Access - Error "Cannot find a record in the table..."
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.
