Linking tables

J

Jenn Connors

I have several tables that I would like to link together. I would like to be
able to make a change in 1 and it will change in all of them. Is that
possible?? If so can you please tell me how.
 
G

George King

Tables are linked in queries by displaying the tables in the query and
draging identical fields from one table to the other. Right clicking on the
resulting line between the tables will bring up an "Edit Relationships"
dialog box.

In that box you can select "Enforce Referential Integrity". That will ensure
that relationships between records in related tables are valid and that you
don't accidentally delete or change related data.

You can also select "Cascade Update Related Fields". That will update
corresponding values in the other tables if you change a linked field in one
table.

You might also want to select "Cascade Delete Related Records". so that if
you delete a record, the linked records in other tables are deleted at the
same time. Might want to think about this one, though. You might *not* want
to automatically delete records in other tables.
 
J

Jenn Connors

Thanks for the help. I tried to do this but I am gettign a error message "No
unique index found for the referenced field of the primary table" Do you
know why I would be getting this error?
 
D

Douglas J. Steele

Did you create a primary key for your table? You cannot create a
relationship unless there's a primary key on the table.
 
J

John Vinson

I have several tables that I would like to link together. I would like to be
able to make a change in 1 and it will change in all of them. Is that
possible?? If so can you please tell me how.
Click to expand...

Step back a bit. If you're storing the same data in multiple tables
and you want it to change in all of them, *you are on the wrong
track*. Each table should contain its own distinct set of information;
you can use Queries to link them together, but the information should
be stored only once, in only one table.

What are these tables? What information are you trying to store?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
J

Jenn Connors

Yes I did on all the tables. But the description for the primary key is not
the same. Does that matter?
 
Top