4 Replies Latest reply on Apr 16, 2016 4:52 PM by beverly

    Relationship with SQL Server Table

    user26943

      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?