How to link 2 tables so that changes in one tables would affect another

1

I have two tables in MS Access 2003. Both have some common columns. Is it possible that if I change the common data in one table it will affect another table. So I would not need to update the same data in each table. I tried to do that directly by typing the new values in sells and pressing SAVE button but it does not work (MS Access 2003).

Anna

Posted 2012-06-25T04:21:42.137

Reputation: 23

1Have you considered normalizing further? – Ignacio Vazquez-Abrams – 2012-06-25T04:23:10.607

Did you say foreign key? – Khaleel – 2012-06-25T04:29:42.457

I did not do anything special. My tables now are not linked to each other. I need to link them. How I can do that? – Anna – 2012-06-25T05:26:21.240

1Normalize further. – Ignacio Vazquez-Abrams – 2012-06-25T06:18:58.863

Answers

0

You need to write some Visual Basic that fires on the control's update event and copies, updates/and or appends, depending on what you are doing the value into the 2nd table.

I always find this code hard to figure out, and often have to spend half a day and dig through my vba (Visual Basic for Access) book but it will work.

Elliptical view

Posted 2012-06-25T04:21:42.137

Reputation: 864

Asked: 2012-06-25T04:21:42.137

Viewed: 373 times

Active: 2013-12-20T19:37:53.350