Hi
Hope someone can help me with this one.I've created an access database 
with three tables (People,Authentication,Contact).I need to insert a new 
recordset to People and retrive the PersonID(Autonumber) which will be 
added to the other tables(contact and Authetication)..All this needs to 
happen as soon as a user has filled out a form and clicked submit.Also 
these tables have been separated because not all users will need to enter 
details into Authentication and Contact tables.I thought using stored 
procedures was the best way to go about it but having used the INSERT sql 
statement a problem arises when two or more users excute it at the same 
time.They end up with the same PersonID.Any ideas?

to prevent the two from having the same..

go back to the table in design view..
choose the PersonID field..  at the bottom
set the Index Property to Yes (no duplicates)
and no one will ever have the same PersonID
number again..

later,
bware

-----Original Message-----
From: Lawrence Mbijiwe [mailto:lawrence@m...]
Sent: Thursday, November 28, 2002 11:12 AM
To: Access
Subject: [access] Help


Hi
Hope someone can help me with this one.I've created an access database 
with three tables (People,Authentication,Contact).I need to insert a new 
recordset to People and retrive the PersonID(Autonumber) which will be 
added to the other tables(contact and Authetication)..All this needs to 
happen as soon as a user has filled out a form and clicked submit.Also 
these tables have been separated because not all users will need to enter 
details into Authentication and Contact tables.I thought using stored 
procedures was the best way to go about it but having used the INSERT sql 
statement a problem arises when two or more users excute it at the same 
time.They end up with the same PersonID.Any ideas?