I’m developing a real estate website focused on condo buildings in the Washington, DC metro area. I’m housing the data in AirTable and via Zapier, it will create/update pages in WordPress.
Two of the tables I have are for [condo] Buildings and Metro [stations]. The Metro is the subway system in Washington, DC.
There are roughly 2500 condo Buildings and 100 different Metro stations. A Building will be near zero or several Metro stations.
In the Building table, there are 3 fields that contain the names of Metro stations that are:
Field 1 - within a 1/4 mile
Field 2 - between 1/4 to 1/2 mile
Field 3 - between 1/2 to 1 mile
Each of the fields can have 0 to several Metro station names.
An example would this abbreviated record for the building Turnberry Tower:
Building Name: Turnberry Tower
Field 1: Rosslyn
Field 2: Courthouse, Pentagon, Virginia Square
Field 3: Metro Center, L’Enfant Plaza
I would like to relate each Metro station name to the corresponding record in the Metro table.
Do I need a junction table? What would that look like?
How do I create a link for each Metro name in one of the 3 fields above?