Hi,

I have a mysql table called records and within that a field called species. I also have a form which inserts records into this table. I originally had in the form a single list menu which list 'Macro species'. This selected value was inserted into teh 'species table field on form submission. I have since added a second list menu called 'Micro species' and what I would like to do is allow a user it either insert a value from the 'Macro species list menu into the species field or a insert a value from the 'Micro Species' list menu in to the species field. I can only get either one or the other. If I get the Macro list working then when try and insert a value from the micro list it just inserts a blank.

Can this be solved and if so can someone help.

Thanks and I hope this makes sense.

Simon

So, you have two list/menus on same page and they should upload same field ? Hope I get you right. Why not two list/menus, in first choose Macro or Microspecies, and depending on selection, in second shown only Micro or Macro values ?