Most recent custID

Results 1 to 3 of 3

Thread: Most recent custID

  1. #1
    Join Date
    Dec 1969

    Default Most recent custID

    Hi,<BR>Suppose the user fills in the form and hits send. Info goes to database table "mytable". But, the CustID number for THAT transaction must now be placed in "myOtherTable". How do I get that CustID number and put it in the "myOtherTable"? <BR><BR>I&#039;m using Access97, SQL. Thank you for reading.

  2. #2
    Join Date
    Dec 1969

    Default RE: Most recent custID

    many ways.<BR><BR>one way is to create a new recordset, open up the new table,<BR>and put that info in there...<BR><BR>not too difficult.<BR>if you were using sql you could create a trigger to do all of that for you.<BR>

  3. #3
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, General

    See the question about "just added record".<BR><BR>

Posting Permissions

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