I have an ASP site using an access database. The main table is an application form. There is a field for industry license numbers but applicants may have a lot more than 1 license number so I need to have an option to "add more" for that field.

Basically what I had in mind was a second table called "more_licenses" with 3 fields "license_name", "number" and "application_link". Then I would pass a id of some sort from the first form to a popup window where they can add more licenses. For reports, I can display the application and the data from the second table when it is there.

The problem is how do I pass the "application link", I can't say "highest ID +1" because there may be lots of people on the application at once and they could link to the wrong app.

Any ideas or does anyone have a better way to do this?

Thanks