Results 1 to 2 of 2

Thread: Primary Key

  1. #1
    Join Date
    Oct 2002
    Posts
    1

    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?
    Thanks

  2. #2
    Join Date
    Oct 2002
    Location
    Northampton, England
    Posts
    4
    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
  •