Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Corrupt table?

Status
Not open for further replies.

CC801340

IS-IT--Management
Jul 10, 2001
147
GB
I have a strange problem...I have a form called "Placements" which gets its data from a query called "Placements". The Query gets its data from three tables, "Candidates", "Jobs" and "Clients" (there are relationships set up only in the query between these tables).

My placements form suddenly stopped me adding/ammending data. I have narrowed the problem down to the "Jobs" table. I have an old version of the table and when I use this all is fine.

Can anyone suggest ways in which I can find out where exactly in the "Jobs" table the problem lies?
 
check the 'referential integrity' on the relationship.

double click the relationship line
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top