I have created a Database(Access 2000) called Restaurants, containing 3 tables named:
CITIES – (fields) > city_id*, city_name, city_comment
RESTAURANTS >city_id, rest_id, rest_name*, rest_cuisine
REST_INFO >rest_name, address, capacity, specialities
fields city_id in CITIES and rest_name in RESTAURANTS are key fields.
The Relation I created is city_id in CITIES to city_id in RESTAURANTS whose rest_name field is in turn related to rest_name in REST_INFO.
What scripting do I need to get one ASP page to show a list of all the cities, and when a city is clicked get the restaurants for that city listed which in turn are links to the info on the particular restaurant.
I assume I will need three .asp pages:
cities.asp, restaurants.asp and rest_info.asp, but
I really have no idea how to go about creating them.
I would really appreciate any help.