help needed populating a list field from a list field in a different table

Hi all,

As this makes for complicated reading I have colour coded as follows: keyword tables field names

in an attempt to minimise the number of list and detail pages used within a website I have created a table called information_pages which contains information on various topics such as places to visit, car park locations etc. within the table I have a list field called "category" comprising of options such as "car Parks" "place of interest" etc and each record in the table selects its relevance type from this list.

The records are called to a list page from a menu using variations on the following;

information-list.php?category=Place of Interest

This all works fine, however, as I am using a single listing page to display information relating to a number of different subjects I need to be able to supply meta tags and introduction text to the page that is relevant to the subject in question if that makes sense.

Ie If the search criteria is category=places of interest I want it to produce a list of matching entries from the "information_pages" table and at the same time populate the metatags and heading text from the second table from a record that also has a "category" field matching places of interest.

I assumed the best way of achieving this would be to create a second table called information_section_headers containing a record for each category type with each record containing fields to populate the metatags and an introduction area on the listing page and then loading both tables when loading the listing page.

The idea is that both tables will be searched for content where the field "category" matches the required subject.

To this end both tables will have a field called "category" and to ensure matching content  I want the "category" list field in the table "information_section_headers" to populate itself using the content from the "category" field in the "information_pages" table. Hopefully this still makes sense.

Unfortunately while I can start setting up the category field in the second table and get as far as the dropdown box to select the table to be used to import from I have no idea what code is needed to replace the default entries in the MySQL Where box or the More Search link box.

If anyone can advise as to what I need in there to populate the field with the list content in the "category" field of the first table it would be appreciated.

Apologies for taking so much time to explain what is probably a simple question but it isnt easy when you dont have a clue what you are talking about. :-)