Results 1 to 2 of 2

Thread: Primary Key

  1. #1
    Join Date
    Oct 2002

    Unanswered: Primary Key

    Hi everyone,
    I am not sure whether to use invoice no as a primary key. I have several suppliers and their invoices no maybe the same. So what shall I do?. Similarly their products may be the same.
    Any suggestion?

  2. #2
    Join Date
    Oct 2002
    Northampton, England
    No, you should not use the invoice number if it is not unique. This will give you problems later. Create an new field in the table and make it autonumber. The products should also be the same.

Posting Permissions

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