hey guys
i have a program that is to do with stock. I have a databse that has two tables in it that are linked with BANDID. the first table has BANDID and BANDNAME and the second has BANDID, TYPE and NUMBER.
BANDID is an autonumber.
What i need is when the user chooses band from a combobox and writes the name of the item in a text box, i want it to add to the second table with the same ID. i hope this makes sense.