form and tables

K

kev carter

hi
i have a database that has several tables in it
i only have one form at the moment
the form contains comboxs, text boxes etc
one combo box contain departments
combobox on form
office
stores
shop floor

i have several tables
example
table [office]
dept fault cost

table[stores]
dept fault cost


the user makes a selection from combo on input

is it possible to save the data entered by the user to a table based on
what is selected in the combo box?

thanks in advance
kevin
 
Top