Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    45

    Unanswered: please somebody Help

    I have 2 Tables Tbl1 and Tbl2 , Tbl1 has 1 field (AutoNO) a number that increments by 1 using a query, Tbl2 has 3 field (SerialNum,Name,LastName) how can I evry time I create New Record in Tbl2 the autoNo will increment by 1 and this new value will be inserted in the Tbl2 new record (new SerilaNum = new AutoNo)?

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    I have 2 Tables Tbl1 and Tbl2 , Tbl1 has 1 field (AutoNO) a number that increments by 1 using a query, Tbl2 has 3 field (SerialNum,Name,LastName) how can I evry time I create New Record in Tbl2 the autoNo will increment by 1 and this new value will be inserted in the Tbl2 new record (new SerilaNum = new AutoNo)?

    Link Tbl1 with Tbl2 by AutoNO in Tbl1 with SerialNum Tbl2.
    Be careful with form that adds records to Tbl2......
    Saludos
    Norberto

Posting Permissions

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