Diffuculty linking tables (1 Viewer)

I am creating a Access Database for a school assignment. It is supposed to be a GIS database (contain spatial data of some sort)

I have a table with all the areas in my city listed with area as the primary key
and a table showing transit routes within the city with route number as the primary key.
I would like to show what transit routes are available in what areas, using route numbers

My problem is that many of the routes run over several areas of the city, is there a way that i can tie these two tables together without creating multiple columns in each?

Many to many relation. Google that. Also, google junction table

Hi Cass.scag

The short version is you need a table in between your two tables that provides the many side of a one-many relationship. it will contain a field to record the areaID and another to contain the routeID.

Ron