Why is the relationship between two tables automatically created?

B

Bagia

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.
 
D

Dirk Goldgar

Lynn Trapp said:
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.
Click to expand...

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.
 
Top