Tracking Number

[ianmuir]

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, 2010 by Guest

[bcooney]

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?