How to save to diffrents table from form input

  • Thread starter Thread starter Ramburst
  • Start date Start date
R

Ramburst

Hai Guys, I really need help for my final year project..

I just developed a form to input data to 7 diffrent
tables. How can I save the data to the table I selected
based on the combo box selection? Let say in the combo box
I select "John" then I want the data I input to the form
be saved to John table only once I click the command
button, and if I select Sam in the combo box then the data
in the form will be saved to Sam table once I click the
command button.

What I must do or any coding?

Thanks a million first.
Ram.
 
Ram, Before going further down this road it doesn't appear you have your
database normalized. Why would you have different tables for each person.
Seems to me you would have a person table and possibly a person_details
table at a minimum. You would then relate your personID(PK) field to the
personID(FK) field of the details table. Am I missing something here? Now
you could easily design a query, add these to tables to the query, join them
on the key fields and if you filtered for John all the records in the detail
table relating to John would be right at your fingertips.
 
Back
Top