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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
