modifying a query

[Zaeed]

Hi,

I have a query which selects a group of people relevent to a department, and since the group is more of a, list of certain people, rather than defined by titles (i.e. the group is the manager, the accountant, the clerk), my query just manually uses the ID's of the people required. (WHERE ID = 245, 234, 1212, 34)

Now my issue is that I want the person administering the db (not me) to be able to modify that query from within the .MDE frontend file (instead of building and distribuiting a new version)

Is this possible?

 

[georgedwilkinson]

Sure, why not?

You could allow them to type in the names, right? Or save the settings from the last run (in a table) and re-use/allow changes to the parameters. There are dozens of ways to handle this.

 

[Zaeed]

ah, just realised this wouldn't solve my problem, since that would only be effective for that particular user.. Not accross the whole system (everyone has their own frontend)...

Would a table that held the list of ID's be viable?

ID___|___Members
1____|__ 321, 234,6435
2____|__ 12, 235,3

where ID could relate the department..