How did tables become dependant?

[Guest]

I am using Access 2003, and when I check object dependencies, I find the
following listed;

'Group Record' is dependent upon 'Parent Details' which is dependent upon
'Attendance List' which is dependent upon 'Child Details'.

I didn't code these dependencies in (afaik), and I have no queries joining
any table to another with a relationship. The tables describe a parent and
child attending a meeting, and have the field names leader.id, location.id
and family.id in common - is Access interpreting these as related fields?

Ross.

 

[Allen Browne]

Did you use the Lookup wizard in table design?
If so, it creates the dependencies.

While it is highly desirable to have relationships between these tables, the
lookup wizard really has some horrid side-effects as described here:
The Evils of Lookup Fields in Tables
at:
http://www.mvps.org/access/lookupfields.htm

If you are using the dependency info in Access 2003, you must still have
Name AutoCorrect turned on. You can expect another raft of problems from
that:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html