Thank you for your response. Currently tblStreet is the master list of all street names in my service area. Wouldn't creating two duplicate street tables introduce redundancy to the database?
Hello,
I have two tables:
tblStreet
Street ID
StreetName
and
tblCellTowerLocation
CellTowerID
OnStreetID
AtStreetID
I am trying to link StreetID in a 1-to-many relationship with OnStreetID and AtStreetID . After that, i want to do a query to display...