Inserting Records into 3 linked Tables using an AUTOID

<i><b>Originally posted by : KevinM (mullarkey@fs5.ee.umist.ac.uk)</b></i><br />What's the best locking procedure when a user needs to add 3 records to 3 linked MS Access tables which are linked via an Auto ID Primary field...<br />e.g<br />My asp page consists of order details entry (table1), order items entry (table2) and order cost centres (table3).<br />So when a record is added to table1 then the Auto ID Access generates needs to be the link field for table 2 and 3.<br />I know I can get it using a DMax function but how can I guarantee that another user hasn't added a record to table1 in between the User1 Update and calling the DMax function?<br /><br />Many Thanks<br /><br />Kevin M<br />

<i><b>Originally posted by : steve</b></i><br />http://www.microsoft.com/data/ado/adords15/docs/adomth03_1.htm<br /><br />here is the different cursors you can use when opening a recordset. when looking for stuff like this i'd look to the object models and see what methods, properties you can use<br /><br /><br />------------<br />KevinM at 5/8/2000 6:50:53 AM<br /><br />What's the best locking procedure when a user needs to add 3 records to 3 linked MS Access tables which are linked via an Auto ID Primary field...<br />e.g<br />My asp page consists of order details entry (table1), order items entry (table2) and order cost centres (table3).<br />So when a record is added to table1 then the Auto ID Access generates needs to be the link field for table 2 and 3.<br />I know I can get it using a DMax function but how can I guarantee that another user hasn't added a record to table1 in between the User1 Update and calling the DMax function?<br /><br />Many Thanks<br /><br />Kevin M<br />