using comboboxes to select table to input data

[Staelens30]

i would like to use a combobox to select the table that the data is to be inserted.

for example if the user selects new in the combobox then the data is inputed in the table for new

and the same would be for used.

 

[pbaldy]

While that can be done, generally it would be a bad idea to have the data split. I'd consider a single table, with a field for new/used.

 

[missinglinq]

Paul is right on the money here with his post! Separate but, and I'm making an educated guess here, identical tables for holding 'new' and 'used' whatever is very poor design, and will create unnecessary work for you. A Yes/No Checkbox for New/Used or a Combobox for those choices is really the way to go here.

Linq ;0)>