tables...(had a mis-spell)

A

arjang

when i have 2 tables that share same fields, how can i edit/update >>>data
in
one table and have the other table get updated too, i tried relationshiping
of the fields, didn't work or i didn't do it right, thank for the help...
 
D

Douglas J. Steele

If the field being changed is the Primary Key of one of the tables, you can
set up a relationship, set it to "Enforce Referential Integrity", and check
the "Cascade Update Related Fields"

If it's not the Primary Key, odds are it shouldn't be in both tables.
 
Top