Results 1 to 2 of 2

Thread: autonumber

  1. #1
    Join Date
    Dec 1969

    Default autonumber

    Hi,<BR><BR>If I enter an order into an ORDERS table and an autonumber field creates an &#039;orderID&#039;, how do I get that number to use in an ORDERDETAILS table?<BR><BR>Thanks,<BR><BR>I.

  2. #2
    Duc Guest

    Default RE: autonumber

    Hi,<BR>if you are using ADO Recordset you can do like this.<BR><BR>ObjRs.AddNew<BR>ObjRs.Fields("FirstNa me")<BR>etc<BR>ObjRs.Update<BR>number = ObjbRs.field("The auto number field go here")<BR>That&#039;s all<BR>Duc,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts