I'm setting up a database to keep records of payments of advertisers to
our village magazine:
I have a main "Contact" panel linked to a "Payments" panel where the
fields include "Payment-from" and "Payment-to".
We need to keep records of all previous payments so each advertiser will
have a number of records in the "Payments" panel but I would also like
to set up a system whereby overdue payments are flagged - something like
"if today - Payment-to is greater than 0 then flag" but I'm not sure how
to get this to operate on only the last payment record for each advertiser.
Any help, or different approach, much appreciated.
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
