Auto numbering with different prefix

[elbeardo77]

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?

[Salesman0Gil]

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)

[elbeardo77]

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?

[Søren Dyhr]

Check this out:

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

--sd

[elbeardo77]

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

Edited August 22, 2006 by Guest