Jet database error message...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm designing a form that involves our company's program sites. I have a
drop down that fills in a field called "Program" that draws from a table
called tblCompanyPrograms.

Because I'm in the thick of designing I go back and forth between form view
and design view however unless the "Program" field is blank when I try to
switch to design view I get an error message that reads...

"The Microsoft Jet database engine cannot find a record in the table
'tblCompanyPrograms' with key matching field(s) 'Program'.

I can't figure out why I'm getting this since the table DOES have a field
called 'Program' which IS that table's primary key field.

Is is normal that I'm getting this error message or can I fix something to
make it stop?

Many thanks,
David
 
I worked on the corruption solution and frankly I don't think the answer is
in that direction. After poking around on a few of the other Access help
boards it appears the issue is probably related to referential integrity
problems between the two tables involved in this form "Table 1" and
"tblCompanyPrograms". The problem is I have no idea how to fix it or even
what information to give someone so they could help.

I can say that both tables contain the field "program" which is in both
tables and is the primary key in tblCompanyPrograms. The two tables are
joined by the 'program' field with a one (tblCompanyPrograms) to many(Table
1) relationship. In the relationship control box the "enforce referential
integrity" is checked.

So how can I fix this and what other info might someone need to help. This
issue has me at a deadend with my project so any help will be a lifesaver.

Many, many thanks,
David
 
Back
Top