foreign key as autonumber

Results 1 to 2 of 2

Thread: foreign key as autonumber

  1. #1
    AlexK Guest

    Default foreign key as autonumber

    In a single ASP script, I try to insert a row in table A and a row in table B. One field in table B is a foreign key which references a primary key (autonumber) in table A.<BR>I insert a row in table A (this works). I get back the newly generate ID (autonumber) (this works). I use this ID to set the value of a field in table A and try to insert a row in table A (this fails). I get "timeout" error message.<BR>

  2. #2
    alexK Guest

    Default RE: foreign key as autonumber

    in the last line of the question, table A should read table B

Posting Permissions

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