AnsweredAssumed Answered

Tracking Number

Question asked by ian37 on Feb 9, 2010
Latest reply on Feb 9, 2010 by daveealex


Tracking Number


Hi I have a record with Name, Payment_date and Payment_ number.

When a person gets paid the payment date is inserted next to their name.
I need a script to insert a number starting at one in the payment_number field.

So now we have their Name, payment date and payment Number.

If I now make a new record, may be days later and use the same person again when they get paid I want it to insert 2 into that records payment_number field.

So every time they get paid the number is incremented by 1 on that record related to that persons name. This must work for other people in the database as well.

Any ideas? Thanks