Create hierarchical bridge table

I need to create a M:M link between two tables with similar structures. (One is historical data. The other is forecast data.) The data is categorized by Market and Submarket, like this: Market S...