updating tables...

  • 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 date 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...
 
You don't store the date in both tables.

One of the basic rules of data normalization is to avoid these kind of
dependencies, and have only one place where a value is stored. You then use
a query combining the tables to get at the value wherever you need it.
 
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

tables...(had a mis-spell) 1
Updating tables when you input new data 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Update Two Tables Using One Form Contents 0
Update primary Key. 1
Access Daily Entry with multiple entries per field 0
Please help 31
linking tables and relationships 3

Back
Top