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',
'Dev Venta Matriz',
'Dev Venta Sucursales',
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.