AnsweredAssumed Answered

Translate a query to FileMaker

Question asked by lilwey on Aug 1, 2018
Latest reply on Aug 1, 2018 by SteveMartino


Hi, I want translate the image's query to FileMaker relationships to generates a sales report, but I have no idea how to do it. Especially when the query looks like:

WHERE venta.Mov IN ('Factura',

                    'Cancelacion factura',

                    'Dev Venta Matriz',

                    'Dev Venta Sucursales',

                    'Factura Matriz',

                    'Factura Especial')

 

So, any help is useful, especially if you have some material about how to work tables from SQL or material about how to do a sales report. The report example looks like the other image

 

Thanks for any help.

 

 

Techanical info: I have connected my FM's solution by ODBC to SQL Server 2008.

iPhone SE.png

`carbon (1).png

Outcomes