Primary Key Question



In my database I have a Sales table. The data in this table will be used
to analyze and summarize Sales related info in various reports.

For Cash Memos and Credit Invoices two different serial numbers are
used by the company. Pre-numbered Cash Memos and Credit Invoices are
issued by the salesmen on the spot of delivery. So on a daily basis, we
will be receiving Cash Memos and Credit Invoices with different serial
numbers as follows.

Salesman 1 0000001

Salesman 2 0000050

Salesman 1 C 0000001
C 0000002

Salesman 2 C 0000050
C 0000051

There are seven salesmen and each pre-numbered Cash Memo/Credit Sales
pad contains 50 leaves.

Can I use these Cash Memo/Credit Invoice numbers as Primary Key for my
Sales Table or should I go for autonumber? Any advice will be highly

Thank you in advance.



I'd use autonumbers as the glue to link the various tables together.

However you also need the Cash Memos and Credit Invoices information. I'd
keep them in one or two fields which would what unique index constraints to
keep out unwanted duplicates.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads