Passing Auto numbers as Session variables

[David_Fuller]

Hi,

I have a large survey which I want to split into different web pages, I want to keep the primary key filtering through onto each page so it keeps it all together, which I would normally do using a session variable. However when I insert the record, I don't insert the primary key field, therefore how do i pick it up as a session variable?

I tried using hidden fields, but it tries to insert a null value. I'm sure I'm missing something really straight forward.

Thanks

[jeremyluby]

Are you using PHP/MySQL

[David_Fuller]

Sorry, it's an ASP application with an Access 2003 database