How can I have two records with one ID?<BR>Can somebody help me please. Sorry for posting it again here. I had posted in database forum but haven't got any response. Time is running out for me. I have to finish this before 5 today.<BR><BR>What I am trying to do is, first user selects some item from the list boxes then I insert them into a table and get the new ID. Now with the newID, I have to insert two records with selecting two other items from the drop down boxes to a different table.<BR>Is it clear or should I send my code?<BR>Please...somebody help me.<BR><BR>THNAKS.