I have one table that is linked with ODBC from mySQL. I have another table in Filemaker with global variables.
The table from MySql, named FMProducts, is from the datawarehouse so the fields are not normalized. It has 4 fields: Year, Date, CustomerName, Product and Quantity
I need to make a dynamic view so when the user choose a year and a customer from combos the report shows the related records with the information summarize. I want to do this without the use of ExecuteSQL. Is it possible?