I have a Job ticket db I'm trying to set up.
It links to another FM file for customer contact info.
I would like it to generate a number on the job ticket every time I create a record. But each customer has it's own prefix, so each customer's numbers would be different to the last.
i.e I input the details into the FM job ticket
Customer A (CA), so job ticket will produce a sequential no. CA0001
- I then input a new record but with a different customer, Customer B (CB), this job ticket will say CB0001.
Is this possible, or do I have to create a different db for each customer so the numbers work indepentently of each other and link back to the original job ticket db?