I want to develop a user friendly query screen that performs the following:
Drop down list of all available fields for any table in the database, for a maximum of five selection fields, and ten additional non selection fields
not all possible fields, selection or otherwise, will be chosen, so there could be as few as one selection field chosen
For selection fields, a drop down list of all entered data in that field will be displayed
All chosen fields are then passed to a report
I need an outline of how to approach this, and specific code for the more difficult tasks