Adding Values to tables

databases Denmark
  • 14 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?

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The generation of random numbers is too important to be left to chance.” - Robert R. Coveyou