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