how to design tables for dynamic queries

[kenndot]

Hi all,

I've got an application where some of the criterion in the queries are hard coded and I am trying to remove all of that hard coding and use tables to make the app dynamic for the user. My question is one of design. I am looking for ideas as to how to design the tables in a way that I can query those tables to make my dynamic select statement each time the user runs the app. They will have a 'default' setting, where I will default the criteria to what is hardcoded now.

Please let me know if my question doesn't make sense or if you need more info.

Thanks a bunch.

 

[kenndot]

wow - thank you all! I think I've got some great ideas now and I'm sure I will be back w/more questions, though, since I'm not exactly sure how to implement all of it.

I appreciate your comments.