Hello,
I have 4 tables in which I plan to join with a union query and be able to query information based off of text boxes in a form. The form will have 5 Text boxes that I can use to limit my queries. Is it best practice to:
1) Have 4 separate select queries (one for each table) that will link to the text boxes from the form, then create a union query?
2) Create a Union query, and then create another select query off of the union query so I can link to the text boxes to the form.
Thank you for your time.
I have 4 tables in which I plan to join with a union query and be able to query information based off of text boxes in a form. The form will have 5 Text boxes that I can use to limit my queries. Is it best practice to:
1) Have 4 separate select queries (one for each table) that will link to the text boxes from the form, then create a union query?
2) Create a Union query, and then create another select query off of the union query so I can link to the text boxes to the form.
Thank you for your time.