Okay so I am running a project for a tour operator. The category pages (repeaters) need to be linked as follows:
Continents Page > Countries Page > Cities Page > City Page > Hotel Page
My database is set out as:
Continent | Country | City | Hotel Name
I have also tried using a database for just continents which seemed to work but when linking it to the countries database it isn't pulling through the correct countries, it is only pulling through all of the countries in the countries database. The structure should be:
7 continents (let's choose europe here for an example) - that page links through to a page full of european countries (let's choose england) - that page should link through to a page full of english cities (let's choose london) - that page should link through to a page describing London with links to 2 hotel pages (let's say premier inn) - that page should link through to a description about the hotel and some photos.