I used to be dangerous with access once upon a time. But I haven't had to make a database in quite some time.
Say I have a form control with a value of x(a). And I have 19 tables with x and y values with one column for all x's and one column for all y's. x(a) appears at least once in each of those 19 tables. I want to run a query for the corresponding y value in each table. How would I go about doing that? Assume I know how to set query criteria based on form controls. I just can't figure out how to structure the query so the y values appear in a single column in my query.
Years ago I probably would have known the answer but today I'm at a loss.