Access problem

Results 1 to 2 of 2

Thread: Access problem

  1. #1
    Join Date
    Dec 1969

    Default Access problem

    Hi. Can anyone help me. I have an Access database where I have 2 tables linked by Order ID. I have made Order ID an automatic number for both. However now, when I add details to the Order ID in one table, it doesnt create an Order ID in the other table.<BR>I am wondering if Enforce Referential Entegrity is needed, but it worked before without it and now it says I cant add it anyway. <BR><BR>Thanks for your help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Access problem

    OrderID needs to be an automatic number in your order table, and a long integer in the second. And then the second OrderID(the long integer) is set as a foreign key in your second table. And you can reference your primary key (automatic number) in the first. I think.

Posting Permissions

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