Can any one tell me whether one can INSERT statement to insert data into more than one table.... also in a form SELECT 5 tables to use for 5 dropdown lists and insert this data into a normalization table ?? have not been able to find any references to this anywhere ... how difficult is it to create 5 dropdown lists on one input FORM can you point me in any direction please or better advise ??