Hi all.
I have a table named 'Query_Req' that contains the fields that are required for that specific type of customer. I also have a table with data that I would like to query (up to 10k records) but only return the fields that customer requires.
Would it be possible to have my query automatically return the required fields from the 'Query_Req'? This table will be updated on an annual basis and required fields might be added/removed.
Ex. For ex. Customer_B only needs four fields, so a query would only return those.
I understand I would need two queries to achieve this and that's okay. I just don't know if this is possible or how to start.