I need to know how I can reference the primary key (an autonumber field) of a record I just inserted in the database. the key is that I can have multiple users at the same time creating records.
I am creating a record (a product) from items in the database, then this newly created product(record) primary key is added to a basket as a forgein key. Can anybody help?
Thanks
Mike

Michael Rudge

I solved similar problem by passing username to next (confirmation page). On this page I filtered records with username and sorted ID desceding. This way, I'm getting last inserted record by user in question. Pulling ID or any oher information isn't a problem.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I need to know how I can reference the primary key (an autonumber field) of a record I just inserted in the database. the key is that I can have multiple users at the same time creating records.
I am creating a record (a product) from items in the database, then this newly created product(record) primary key is added to a basket as a forgein key. Can anybody help?
Thanks
Mike

Michael Rudge
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>