Save Data in different tables using single form

[amit]

Hello Everyone !!!



I have created single form and 7 different tables. In my form I have a combobox which have different branch names (Table names are as per combobox values). Now what i want to do is whenever I select a branch name from combobox and click on the save command button the particular record should be saved in particular table.

Please help me in this regard.

Thanks.

[JoeM]

Sounds like you may have a design issue.
Do all your seven tables have similar table structures?
If so, then why do you have seven tables?
It sounds like maybe you should just have one table, and then an additional field to indicate whatever "category" having different tables was supposed to accomplish.