AnsweredAssumed Answered

Client ID Help

Question asked by HankCieplinski on Feb 11, 2011
Latest reply on Feb 11, 2011 by philmodjunk


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.