Relations on Tables

K

kon

How can I have one table with a uniqueID having relationship with 2 tables
each one have one uniqueID and using Enforce Referential Integrity and
Cascade Update Related Fields. For example
Table One and Field UniqueIDOne having relationship both with the two tables
table Two and three.
When I tried to Update the table One it's says that I must enter data to
table two or three.
thanks a lot.
 
J

Joseph Meehan

kon said:
How can I have one table with a uniqueID having relationship with 2
tables each one have one uniqueID and using Enforce Referential
Integrity and Cascade Update Related Fields. For example
Table One and Field UniqueIDOne having relationship both with the two
tables table Two and three.
When I tried to Update the table One it's says that I must enter data
to table two or three.
thanks a lot.

Are you trying to enter data in a table? Tables are just for storing
data. Try doing your editing in a query, report or form.
 

Ask a Question

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.

Ask a Question

Top