Help with relationships

[moishy]

I have 3 tables:

City:
ID (PK)
City

Neighborhood:
ID (Number, indexed)
Neighborhood

Street:
ID
Street

I want to create relationships so the city table will expand to show all neighborhoods in the selected city, and the neighborhood table (which shows when a record in the City table is expanded) will expand to show all streets in that neighborhood.

I hope I was clear enough.

 

[John Big Booty]

I'd probably do something along the lines of;

Tbl_City
CityID (PK)
City

Tbl_Neighborhood
NeighborhoodID (PK)
CityID (Number, indexed) (FK)
Neighborhood

TBL_Street
StreetID (PK)
NeighborhoodID (FK)
Street

 

[John Big Booty]

The sample here works along a similar structure.

 

[moishy]

Thank you. So far so good.