Gii Systems 8/30/2016 9:24:20 AM
Hi Jeff, I guess you could do this as follows:
Lets assume you have the Id column for the Client in this table - I call this [Client Id]
1. Create a many to many relationship within the same table with a match condition where [Client Id] = [Client Id].
2. Create a summary column within this relationship to count the number of records for this client and call it: [No of Records for this client]
3. Create a Formula Numeric column called [Client AutoNumber] with a formula such as: [No of Records for this client] + 1
4. You can then use formula columns to prefix this number. Maybe a formula Text like: List("-",[ClientId],[Client AutoNumber].
This will create a Unique number that looks like 15-1 the next in the series will be 15-2 etc.
Hope this helps?