adding to database using comboBox and Text boxes

[kmm4548]

here's what I want to do:

when the user selects a client name from the combo box, i want to populate labels with info(from the database) that the user can't change (client name, number...) i think i have this working by using the datasource & datafield properties of the label.

then i want the user to be able to add information into text boxes such as invoice number, comments.

i then want to create a new record in the database using all of this information.

i am using ADO controls, i have the combobox linked to an ado control that responds to SQL. the information that i want to go into the database needs to be put into seperate tables that are joined by keys.

if anyone has any suggestions, i would really appreciate it.


Follow Ups:

 

[Morpheus1981]

"that i want to go into the database needs to be put into seperate tables that are joined by keys."

You here didn't say tables Names, or RecorsetNames anything. How do u expect an answer if don't know all what is happening. I can give an answer but may is not what u really need. Please the next time be a little more specific a little more....