AnsweredAssumed Answered

Differently Incrementing Serial Numbers

Question asked by DanielClark on Jan 11, 2011
Latest reply on Jan 11, 2011 by philmodjunk


Differently Incrementing Serial Numbers


I have a Contacts table with a ContactID field that is auto-incrementing serial number field that just increments whenever a new contact is added. I also have a Relationship field which defines the Contact's relationship to my company ("Client", "Employee", "Vendor", etc). I want to set up another field called EmployeeID in my Contact's table that only creates and increments serial numbers whenever a contact's (whether they're new or not) Relationship field is set to Employee. How do I do this? Thanks.