Hello Richard - In Beginner-4, Video-6 @ at the 2:45 mark you explain that the 'CustomerID' is really for Access, not for me (the user), and can't be customized short of some programming. If I were to create a new input field with something like a customer "Code" with a prefix such as "CST-xxxx", will this new field complicate life when I begin to set up relations to other tables later down the road? Thanks!
Reply from Richard Rost:
Yes, you will complicate things tremendously. If you want your own "code" then that's fine. There's nothing wrong with TWO fields: an ID Autonumber and your own manual typed-in code. You'll use the ID for relationships later, but you can still print YOUR customer "code" on invoices, etc.
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 Beginner 4.
