Title
need help creating a FMP calculation
Post
I need to create sequential tracking numbers for contracts that I will be creating in an FMP database. However, the contracts will need different amounts of tracking numbers depending on the size of the unit the customers order. For example, a single unit (S) = 1 tracking number; a feature unit (F) = 2 tracking numbers; 1/4 page (Q) = 4 tracking numbers; 1/3 pg (T) = 6, etc.
I'm trying to think of a way to get FMP to generate the tracking numbers for me. There is obviously a lot of room for human error. The other problem is that there may be multiple records for one contract so the tracking number often needs to be the same for each record in the same contract. Instead of marking these records with a regular unit size letter (S, F, Q, or T) they get a * in the contract (S*, F*, etc.) to mark them as additional records within the same contract and not different units (which would be more $$).
I can change any and everything about this but I'm stuck. HELP! Thank you!!!
How are your relationships set up?
Are multiple records for one contract, multiple orders for one contract for one customer? Can a customer also have multiple orders that are not based on multiple records .
What does...a single unit (S) = 1 tracking number... mean? How many digits/numbers? How does it get a (S) designation?
What determines a 1/4 page or a 1/3 page, number of items or just actual length?