By Richard Rost 4 years ago
Create Customer Codes that Don't Reveal Your Database Size
You don't always want your customers seeing their CustomerID. If someone gets assigned a low number, they'll know you don't have much business. In this Microsoft Access tutorial, I'll teach you how to create custom Customer Codes that are based on DateTime stamps and random numbers.
Bethany asks, "I’m using an AutoNumber for CustomerID, however I don’t want my clients knowing how many customers I have. If XYZ Corp sees that they have CustomerID 15 then they know I don’t have that many clients! How do I give them a Customer Code that isn’t dependent on an ID field?"
There is no Extended Cut for this video.
Subscribe to Customer Codes
Get notifications when this page is updated