Query In MS ACCESS

  • Thread starter Thread starter Ravi
  • Start date Start date
R

Ravi

i want to establish a link between two tables in the same database (MS
ACCESS) so that if i update a record in one table it automatically
gets updated in the other.
 
i want to establish a link between two tables in the same database (MS
ACCESS) so that if i update a record in one table it automatically
gets updated in the other.
Click to expand...

The need to do so suggests that you're storing "the same" data in two
different tables. *This is a bad design*.

Relational databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place". You would store data in the
table appropriate for that data, and then use Queries to link to it in
conjunction with data in other tables.

What specifically are you storing in these tables, and why do you feel that
you need to have "the same" data in two different tables?

John W. Vinson [MVP]
 
Back
Top