Formula Syntax Error Question
Hi All, Here's the formula I thought would work: todate(max(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1))) The logic is, find all records where fid 756 (related f...
Forum Discussion
I ran into a similar issue. Fortunately I already had a relationship between the two tables and the table where I needed the data was the parent table of the relationship. I created a max summary field in the relationship that returned the value I needed and used "Only summarize records where the following are true to handle the conditions of the query.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------