5 Replies Latest reply on Jan 11, 2011 11:12 AM by philmodjunk

    Differently Incrementing Serial Numbers



      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.