I have a database that has a many to many relaitionship between people and the reports these peolpe are related to. I am working on a form for one of these reports. So far, I have a subform on the report to list all the people associated with the report. There's a combobox that lists all the people, and to enter them into the subform you just have to select the person from the dropdown box and add that person to the subform. This works great.
Now, often times, a report will apply to people that have something in common. So for example, all the people working in the finance department. And there could be about 50 of them, and it's hard to tell everyone that's in the finance department from a simple combobox. I would like to add functionality that allows the user to add a group of people based on a query. I've had a few failed ideas, but perhaps someone else can think of a way to achieve this functionality.
I currently can get a list of the names of the saved queries, and have the user select one, but once they select I have no idea how to get the underlying sql or to actually run the query. And since the users won't know SQL all that well, it would be useless to put in a textbox for them to type sql. Any ideas?
Now, often times, a report will apply to people that have something in common. So for example, all the people working in the finance department. And there could be about 50 of them, and it's hard to tell everyone that's in the finance department from a simple combobox. I would like to add functionality that allows the user to add a group of people based on a query. I've had a few failed ideas, but perhaps someone else can think of a way to achieve this functionality.
I currently can get a list of the names of the saved queries, and have the user select one, but once they select I have no idea how to get the underlying sql or to actually run the query. And since the users won't know SQL all that well, it would be useless to put in a textbox for them to type sql. Any ideas?
