We need to obtain a value from a record based on filtering an unknown amount of records in a summary field on a different layout than the report, for the date the record was created. Sorry for the long sentence. Just trying to explain my self. Were running fmp14.
Thank you!
Please ask questions if there is anything you need to know.
Is the "different layout" based on the same table occurrence as that of the report's layout?
What kind of filtering? What data/criteria specifies which records to include or exclude?
General options that might work: