Question Locked

one to one relationships in access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how to creat a one to one relationship in access 2007 . it only enables me to creat one to many relationships pls hlp?

2 replies

by tony hopkinson

One to one, or one to many depends on whether
the fields are primary keys

Customers keyed by CustomerID will be one to one with CustomerAdditional also keyed by CustomerIDs

It will be one to many with say CustomerAddresses, keyed by CustomerID and AddressID.

This discussion is closed to new replies.