I have a search form that needs to search two databases.

So right now using cdml I have hidden field -db=publications

Search fields title, author, etc.

However in a related database I need to do a search on language of the pub

so database=pub_language

and the field is language

How can I point to this database in the same form using cdml?

FileMaker Version: 6

Platform: Mac OS X Panther

Use [FMP-InlineAction] tags in the Format file to search the second database. You can use Tokens to pass any search criteria.

All the best.

Garry

We are modifying things and very close to getting what we want.

However using a pop-up selection I can not get the search to do what we want.

For example: A publication is either a) English, : French or c) English/French

When the option for English publications is selected, we want to show all the a) English publications and c) English/French publications.

Currently here is the code:

<select name="LV PLID_Sort::PubLanguage_E" size="1">

<option></option>

<option value="English">English / Anglais</option>

<option value="French">French / Francais</option>

<option value="Other">Other / Autre</option>

</select> -->