For fun I have a database that records all the beers I drink. The two tables I am concerned about are BeerLog which records the beers, date, score etc and Beers which keeps information, such as the name, brewer, ABV etc, about the beers themselves. The two tables are linked via a field, BeerID which appears in both tables.
I have been trying to use the MAX function with the following:
ExecuteSQL ( " SELECT MAX ( Score ) FROM BeerLog INNER JOIN BeerLog.BeerID ON Beers.BeerID = ? ; " " ; " BeerID " )
as the calculation for a field, MaxScore, in the Beers table which appears on a layout based on the Beers table.
Whatever I do to the above statement I always get a blank in the Edit Box related to MaxScore on the layout.
I am using FileMaker 12
What am I missing something? Any help would be appreciated.