Adding record to multiple Tables

[dntel123]

Hey people,

I'm trying to work out a way to let the user of my program add to the database. But i Have 6 tables that i want them to be able to add to, representing 6 different university modules.

I'm not sure of the correct way to go about this, dont really want to have 6 different forms for each table.

Just wondering if anyone knows a way i could achieve this from one form, like maybe selecting the table using a drop down list to select which table then updating that way:

for example If Me!cmbModules = "Name of Table" Then update this table

ANY ideas would be really helpful thanks a lot guys

Liam

 

[Rabbie]

I think you need to look at your design and check that your data is properly normalised. It is rarely necessary to have 6 tables with similar structure in the same DB so it may be possible to have one table holding all your module records. This would make it easier for you to hav one form to update the module information.