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

Edited February 8, 201015 yr by Guest

Actually, you might try just putting the @@ symbol next to their payment record in a portal. Do you have other tables? Such as Person and Payments related by PersonID, perhaps?