Im converting an Access database with VBA to filemaker in order to make it accessible on mac.
The original database that I created is very simple and i have almost fully completed the migration. However when it comes to reporting here is where I have encountered a problem.
The current database is used to create records for transactions much like a till. With each record being assigned a method (cash, card or cheque)
The report is used to print a daily record of how much money has come in via each method (attached a screenshot below)
Currently in the access record I use the following code to obtain the data from the tables.
This coding allows the report to show the amount instead of the actual method used.
How do I go about replicating this in filemaker?