Murray Brown
asked on
Access Parent Child relationship
In Microsoft Access table relationships, is every relationship a parent child relationship and what determines whether one is the parent and the other the child.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Some relationships a Many to Many, usually requiring a third 'join' (or 'union') table. And examples is:
One Teacher, Many Classes <> One Class , Many Teachers ..... with a table to link the common ID's
Also,
One Teacher, Many Students<> One Student, Many Teachers ..... with a table to link the common ID's
mx
One Teacher, Many Classes <> One Class , Many Teachers ..... with a table to link the common ID's
Also,
One Teacher, Many Students<> One Student, Many Teachers ..... with a table to link the common ID's
mx
ASKER
Thanks very much for the rapid answers
one is the parent and the many are the child
see this link for more info
http://support.microsoft.com/?kbid=304467