Is there any way we can have an auto-increment field that starts over based on what connection is used?
Record 1, Connection 1, Number = 1
Record 2, Connection 1, Number = 2
Record 3, Connection 1, Number = 3
Record 4, Connection 2, Number = 1
Record 5, Connection 2, Number = 2
So each time my users add a record that is connected to their Company the record ID will increment by one for that specific company unlike the auto-increment field which increments no matter the connection.