Create one-to-one Relationship

D

danLycos

With Access2000, I'm able to create a one-to-many relationship using the
CONSTRAINT clause. How do I create a one-to-one relationship from code?
 
V

Vacation's Over

depends mostly on why, or what you want to accomplish.

simple workaround
new table with 2 fields for matching the one to one

use case: matching rider with bicycle
table of bicycles
table of riders
table matching for today one rider to one bicycle
matching table set not to allow duplicates of date/rider/bicycle
 
D

danLycos

I'm importing three tables (using TransferDatabase): Sales Order Header,
Sales Order Detail and Game Detail. I then want to create a relationship
between the Detail tables to the Header table to allow Cascading Deletes.
 
Top