Recordset Question
Hi there,
I am trying to build a directory which displays listings of accommodation providers. The different locations in which the accommodation may be are stored in a table, organised in a hierachy. The basic fields are AreaName, AreaId, AreaParent (which gives the AreaId of the parent area if any) for example:
- England (COUNTRY)
- South-West (REGION)
- Devon (COUNTY)
- Cornwall
- Somerset
- Dorset
- Another Region
- more counties
- and another
- Another country
In the accommodation listings table, the column ListingArea gives the AreaId (from the areas table) in which the listing falls - this may only be one of the bottom level locations (the individual counties). The user is able to select the county in which they want to search.
My problem is this: I would like to make it possible for the user to select a broader area, for example "South-West" and for the results page to then pick out results from all the counties within that area. Is there a way of doing this using the existing linking field (which gives the id of the county in which the accommodation is) or would I need to add in fields to reference the country and region too?
Sorry if this isn't clear - I've tried to explain what I'm trying to do, but I think I may have made it less clear! Many thanks for any help!
Dan
Read More