I have a form with a drop down consisting of Plan_Numbers. When you input a plan number or use the dropdown, the subform in which I need to query has 2 link tables from different databases into my main database form, I had to separate the Historical DB because the database was over 2gigs. I created another Historical database which consist of Historical_2013-2017 data which I need to query with the current. My problem is how do I just query the two tables together and pull just what I need in the form based off the Dropdown Plan_Number (Example: 1125).
Link Tables:
HistoricalData
HistoricalData_2013_2017
Link Tables:
HistoricalData
HistoricalData_2013_2017