How do I get ID number from just Submitted data?

[Christopher Teegardin]

Ran into a little problem .....
I am making a trade request form that collects data from drop down menus, generates an email to individuals in my department with a link to a response form, and allows them to enter their answers into the response form (adding additional data to fields in a row).

Problem: the primary key is an auto_increment ID number. After the new survey questions are posted and a row is generated, I've been unable to get the specific ID number for that row (needed to make the link for the specific row of data). None of the data in the row is unique (i.e. it all comes from drop down menus), so a "SELECT id FROM table WHERE field1= '{$field1}';" solution doesn't work. Is there any way to get that id number?

Thanks,

Chris