Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
Have you considered normalizing further? – Ignacio Vazquez-Abrams Jun 25 '12 at 4:23
Did you say foreign key? – Khaleel Jun 25 '12 at 4: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 5:26
Normalize further. – Ignacio Vazquez-Abrams Jun 25 '12 at 6:18

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .