AnsweredAssumed Answered

Creating individual letters rather than reports (parameter query equivalent)

Question asked by craigh on Feb 1, 2009
Latest reply on Feb 1, 2009 by Sorbsbuster

Title

Creating individual letters rather than reports (parameter query equivalent)

Post

Hi,

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?

 

Many thanks

 

Craig 

Outcomes