Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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
1  
Normalize further. –  Ignacio Vazquez-Abrams Jun 25 '12 at 6:18
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.