AnsweredAssumed Answered

ExecuteSQL question

Question asked by ChrisPye on Apr 28, 2014
Latest reply on May 1, 2014 by Mike Duncan

I have a 'Clients' table with a related 'Contracts' table, there is a field in the 'Contracts' table 'Signed' (boolean) and a field 'Value' (the dollar amount), and a 'ContractDate' field.


I want to show a Value for each Client record from their last signed Contract. I know how to do this via creating extra FM relationships, but in this case it is for a very infrequently used report, so I figure the ExecuteSQL may be a better option.