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?
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?