Example: Client master table -with a link for members of a common
group( may or may not apply to client ) Customer table with for
outstanding balances on account.
A form/report desined from Customer.table.At runtime you may want a
collective or a selective report for a particular report.ie group by
link or ungrouped.
From the Combo Box select Table : Client
From Combo2 select : link from table
From Combo3 select : =
From Combo4 optionally to expand on selection or save
Additional problem : Having selected fields and operators ,a filter
form should pop up showing the fields descriptions selected with
textboxes for users to enter the values at run time.
The next time the report is required it may be on client.resigned
field or a client.type field from the table client.
The common field for the two tables is a client reference filed.
It is this flexibility that I am after and hope that my problem and
goal is a bit clearer
now.
Thank you for your reply.