I'm building a work order (service) database. Each account has an account number, and are assigned Project Numbers, the account number never changes but the work order number and Project number do. What is the best way to make sure that the account number is always associated with the specific account? Would the Account Number be the primary key? I know that it's a primitive question but I am unsure about it.
Reply from Alex Hedley:
Make it an AutoNumber, this will auto increment and not change,
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 10.
