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).
Asked
Active
Viewed 391 times
1
-
1Have you considered normalizing further? – Ignacio Vazquez-Abrams Jun 25 '12 at 04:23
-
Did you say foreign key? – Khaleel Jun 25 '12 at 04:29
-
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 Jun 25 '12 at 05:26
-
1Normalize further. – Ignacio Vazquez-Abrams Jun 25 '12 at 06:18
1 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
- 1,160
- 12
- 23