tables...(had a mis-spell)

  • Thread starter Thread starter arjang
  • Start date Start date
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...
 
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.
 
You must log in or register to reply here.

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

Similar Threads

updating tables... 1
Updating tables when you input new data 0
linking tables and relationships 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
Adding new records to multiple tables. 4
Trying to add a field from another table on a form 1
Update primary Key. 1
spell check entire database 3

Back
Top