Value list & a self-join relationship

[gary jones]

On a CDML page I am passing a query via a link that originates a page containing data from database A. This data is the name and address of a manufacturer. Each manufacturer is assigned to a category.

On this page I am also passing an FMP-inlineaction to search another database, database B, that searches for this manufacturer's distributors based on this category.

[fmp-inlineaction: -db=databaseb.fp5, -lay=table, category={fmp-currenttoken.1}, manufacturerid={fmp-field:manufacturerid}, -find]

Database B is a many-to-many join table that features many occurences of the manufacturers id as each time a distributor is assigned the maunfacturer id is also assigned to each record. This search obviously shows records that match the manufacturer id and category id shown as FMP-currenttoken.1

What I am trying to achieve is to get the search to pull through the town in which the distributor is based into a value list to allow for easy selection. The code I have is:

<select name="searchtown">

<option value="" selected>- Select a Town -[FMP-option:searchtown]

</select>

after which comes the [/fmp-inlineaction] tag.

In database B I have a value list field, searchtown, that shows a list of towns based on a self-join relationship with manufacturerID as the key. Therefore every time I do a search in FMPro and click on this field the value list only shows the town of those companies who have been returned in the search.

However, I cannot get this information to pull through onto the page in the browser. I've even tried setting up a similar field and relationship - so it's not a self-join - with another database and this doesn't work. Any ideas would be appreciated.

Thanks

GARY

[gary jones]

Sorry. Ignore my last request, I've just searched and found everybody else's comments aboout value lists and relationships in CDML. Roll on FMP 6!