2 lists in one report
I am putting together a database for producing sales quotations. For a number of years we have used Access for this but now want the package to be MAC compatible and so are recreating it in FM10Adv.
As each product line is entered there is a field which may be selected to make a product line an optional item rather than include it in the grand total.
I then want the quotation report to list all the included items and prices and then have a "Optional items" header and below that list the optional items. Only the included items will then be included in the total at the foot of the report.
In Access I just inserted 2 subreports in the body of the report - How do I achieve the same thing in FM?