one to one relationships in access

By inoka medagoda ·
how to creat a one to one relationship in access 2007 . it only enables me to creat one to many relationships pls hlp?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Collapse -

It's doing what it can.

by Tony Hopkinson In reply to one to one relationships ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums