Hi

I am kind of a novice in Access, so hopefully this question makes sense.

I want to build a Query that will pull certain fields from two different tables. To make it easy for an end user to decide which fields from each table to take, I'd like to create a table that holds each Query argument in it (tbl_Query_Holder). Then to add or take away an result from the Query, the user can simply remove that field from the tbl_Query_Holder via a form. I set up the tbl_Query_Holder to have 3 fields: Index, TableName, and FieldName. The TableName is the name of the table the Query will be pulling from, and the FieldName is the name of the field in that table to grab.

My question is once I have tbl_Query_Holder populated, how do I generate a Query based on the info in it?

Is this even possible? If not, is there a another way to accomplish what I am seeking to do?