Query In MS ACCESS

[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.

 

[Daniel]

If you setup relationships between these table it will do it for you
automatically.

Look at:
http://www.functionx.com/access/Lesson12.htm
http://www.functionx.com/access/Lesson13.htm
http://www.functionx.com/access/Lesson14.htm

 

[John W. Vinson]

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.

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]