automatically adding data to a repeating field or a portal field
I am trying to move over a database app we have in filepro at the moment to filemaker 10 (or 11 shortly). I need to add an amount to a field automatically depending on the current date. IE if a due date is => todays date add £10.00 to a field and a date to another field. This would need to happen on all records in the database.
I can do this easily in filepro and excel but i am struggling in filemaker. If scripted it could be linked to a report as we run reports monthly. Any pointers woulkd be appreciated. Mike