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.

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.

Related Discussions

Related Forums