Adding customer ID
<!-- / icon and title --><!-- message -->My database includes a table with a list of business contacts that are potential customers. In the table I have included a "customer ID" field which is currently empy. I would like to be able, whenever a deal is done, to assign a customer ID to my contacts using the auto-serial function.
Ideally I would have a button saying "assign customer ID" and a new serial would be assigned at the press of that button, otherwise the field stays empy. Is it possible?
Thanks<!-- / message --><!-- controls -->