pat_nospam
Registered User.
- Local time
- Today, 02:03
- Joined
- Oct 14, 2003
- Messages
- 151
Okay - I didn't know whether to post this in queries or forms, so here goes.
My users need to be able to have more control over extracting data from the tables in a dynamic fashion. I envision them being able to go to a form, click on a pull down box which is populated with the table names - which, when clicked populates another pull down box with field names, which they can then select multiple field names and populate a report with them.
Is such a venture possible? Is there a straight forward method to doing this?
Currently, I just generate commonly used reports for them, but they want to have more control with fewer phone calls to me for development of queries.
Thanks in advance for all your help!
Pat
My users need to be able to have more control over extracting data from the tables in a dynamic fashion. I envision them being able to go to a form, click on a pull down box which is populated with the table names - which, when clicked populates another pull down box with field names, which they can then select multiple field names and populate a report with them.
Is such a venture possible? Is there a straight forward method to doing this?
Currently, I just generate commonly used reports for them, but they want to have more control with fewer phone calls to me for development of queries.
Thanks in advance for all your help!
Pat