Fix relationship problem

[Janet Russell]

Access has apparently hiccupped and, even though
everything says the relationship between two tables exists
and is correct, the relationship is not recognized when I
try to link a subform. I've deleted and recreated the
relationship many times, but nothing changes. How can I
force Access to clear the relationship setting from all
aspects of it's memory?

 

[GVaught]

many times when you think you have deleted a relationship between tables;
you have not. You must delete the join line first and then the tables. If
you delete the tables first you don't delete the relationships. Open the
relationship window and select to Show ALL Tables. My guess is that you will
get more tables showing. Delete the joins first then the tables you don't
want.

Also make sure you have checked the box 'Enforce referential integrity' on
all table joins so that you get the one to many relationship join line. If
you don't then mainform/subform joins won't work.