Why is the relationship between two tables automatically created?

[Guest]

Hello,

Hope someone can help me out. I have two tables: employees and salary. The
related field is employeeid. When I go to the relationship window and add
the two tables to establish relationship, I noticed that it's already created
for me? How does that happen?

I thought you have to manually create the relationships yourself.

 

[Lynn Trapp]

If you have 2 fields named identically in 2 tables, Access will assume that
you want one to be a Foreign Key to the other table.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Dirk Goldgar]

If you have 2 fields named identically in 2 tables, Access will
assume that you want one to be a Foreign Key to the other table.

However, Bagia should be aware that Access will not automatically
enforce referential integrity on that relationship. If you want to do
that, you have to edit the relationship.

 

[Lynn Trapp]

Thanks for adding that important bit of information, Dirk.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html