I'm in the process of redesigning my database app and can't quite get an aspect to work. Put simply, when I add a batch reference into my database for a customer the batch number must run concurrently according to the customer.
For example. I add 5 batches for Customer A (1,2,3,4,5). I then add 3 new batches for Customer B (1,2,3). If I use an auto increment field, Customer B would get (6,7,8). How would I allow each Customer to maintain their own batch sequence?
Can anyone advise on how I would achieve this?