Editing Relationships

[slrphd]

I am having a problem linking two tables so that the first provides a drop-down pick list for the second. The first table is a list of names that I use multiple times in each record in the second table. I was able to make the connections using the look-up wizard and edit the relationship to set the "Enforce Referential Integrity" bit. Everything worked exactly as desired for several weeks.

Then, it happened.

As development of the database continued, I found it necessary to change the name of the second table, which appears to be a cardinal sin. Changing the name and tracing ti through the system was easy enough (I think). The problem that I am getting is that when a try to link the first table a second time and edit the relationship, I get the error message: "Microsoft Access can't create this relationship and enforce referential integrity. Data in the second table violates referential integrity rules…. Edit the data so that records in the first table exist for all related records." The data in either table has not changed so I do not understand this error message. Can anyone enlighten me?

I have done the following:
 After changing the name of the table, I deleted all relationships and tried to create them anew (no dice form Access);
 Went back to an earlier version known to work and deleted all links to the second table, copy into a table with the new name and tried to recreate the links (still no dice).

Breathless in D.C.

 

[slrphd]

Editing Relationships 2

Pat,
Thanks for your response. I looked at the foreign keys and, interestingly, there were fields listed that I did not assign. I deleted those entries. I did not find any foreign keys with the value 0. Even though I cleared these spurious foreign keys, the problem persists. I have given myself a work-around by not enforcing referential integrity and that seems to be OK but I am uncomfortable in doing so. Thanks again.

Steven Ross


Old Chemists never die, they just fail to react.