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.