Creating individual letters rather than reports (parameter query equivalent)
I'm new to FM and this board so apologies if this has been asked 1000 times previously.
I am an experienced Access and Open Office BASE user and am currently trialling FM with a view to purchase at the end of the 30 days. I need to make sure in that 30 days that FM will do everything that I can currently do using standard SQL queries.
What I can't figure is how in FM I can simulate what I can do with say ACCESS with parameter queries. In particular I have about 3 different letter layouts that I send to individual clients:
1) Welcome letter
2) Payment reminder letter
3) All payment received letter
How I do this at the moment in ACCESS or BASE is to prepare 3 standard reports which are all based on a SQL parameter query with the parameter being an Invoice ID (i.e. primary key to a unique invoice table).
Please can someone how I can do this in FM?