I have two tables with one common field, so I’ve learned that I can go to Tools, and then Relationships, and connect, or join these two tables with a line from the common field of one to the same field in the other. But I can’t tell that it helps me in any way. My form and subform still see the two tables independently. What am I missing?
I’ve found that the tables have to be joined for a query to be able to see data from each. And then a form can be directed to look at the query. I’m gettin’ there! Slowly.
(comment → Answer for Resolution)
@DonLow writes:
I’ve found that the tables have to be joined for a query to be able to see data from each. And then a form can be directed to look at the query. I’m gettin’ there! Slowly.