I am trying to write a script that will select a specific repeating field based on a find result. Can anyone help?
I have a FM12 database for raising client invoices and I have the odd occaision where multiple payments are made against a single invoice. As this is rare, I have just set it up as repeating fields for "Amount" and "Date paid". For tax reporting purposes I need to list payments (not invoice totals) within a period of time. I have set up a list layout for this function but I need it to choose the correct payment from the repeating field (rather than list all of them). Is this possible?