Client ID Help
Can anyone tell me how to set up an auto incremented client ID that stays true to the client if the client has more than one record in my database?
I know how to set up the auto entered increment by 1 filed, but when I find a particular client, I want the user name to remain as well as pertinent info that stays constant, such as last name, first name etc, but when I add a record for that particular client, I want the client ID and other contstants to remain while being able to enter variable information.
I am designing a database where there are numerous records for the same client.
Thanks in advance for any help provided.