Adding Values to tables

• • Reply

  15 years ago

  by Nitralus

  Niklas Aagaard

  , Denmark

  Joined 15 years ago
  Making a Database in MS Access 2003. I got 9 different tables, 8 of them related to the one. In the main table (called MainTable) i got a PK number called CV. Now, when i enter this value in a form, i would like it so, that all remaining 8 tables have their PK CV field updated to match the one i just wrote, but how do I do that?
  
  So pretty much: Enter a CV value in the MainTable, and an AfterUpdate funktion happens to add the CV value from the MainTable to Log1, Log2, Log3, Log4, Log5, Log6, Log7 and Log8.
  
  Any suggestions?
  Report abuse