&nbsp;<BR>Hi everybody.... <BR>Ok, I have a form which will enter its contents into one table of a database. <BR>What I am trying to do with this form is create a drop down list which, depending on what item is picked on the list, will recognize the table to enter the information into that particular table. <BR>Is this possible? IF so can someone please tell me how to do this. <BR><BR>I also want to have the page generate an ID number according to the drop down menu, one other field in the form (state) and an autogenerated number (say it will start with 001). Any Ideas? <BR>