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?

If the numbers after the prefix do not have to be seqeuntial for each customer, for instance:

CA0001, then CB0002, then you could have an suto enter field for the number that is set for a serial value, Then have prefix stored in a related table, then have a field that puts them together.

The definiation would look like this:

Cust_Pre&GetAsText(Next_Number)

Each customer has their own number, and each numbering runs independantly of each customer.

i.e Customer A = CA0010, CA0011, CA0012

Customer B = CB0049, CB0050, CB0051

Can I do this?

Check this out:

http://www.filemakerpros.com/SerialCat.sit

--sd

I've tried this but it doesn't really work with what I'm doing.

Edited August 22, 200619 yr by Guest