Relationship with SQL Server Table

Discussion created by user26943 on Apr 16, 2016
Latest reply on Apr 16, 2016 by beverly

Hi Everyone,

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

Captura de pantalla 2016-04-16 a las 17.50.15.png


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?