How exactly is it done? I've read enough about the definition but as far as
setting it up, I don't know how it works. Thannks.
Join two tables by joining the Primary Key of the first table to the Primary
Key of the second; or join them on a field which has a unique Index in each
table.
Note that unless you're using "Subclassing", "Table driven field level
security" or a couple of other even rarer special cases, one to one
relationships are very rarely needed. After all, you can combine the fields
into just one table. Why do you feel that a one to one is needed? What real
life entities do these two tables represent?
John W. Vinson [MVP]
