I have created a search that displays many records in a table. Im trying to create a link in each record in the table that will take a specific field in the current record (called subject) that is clicked and perform a FIND in ANOTHER database. So, for example.

Table 1 has for example 15 records.

The user clicks on a link embedded in one of the records. I want to take a field called "subject" and do a search on a different database with "subject" and create Table 2 from the results.

I know it involves passing a token but Im finding it a bit confusing.

Here is the code that I used to build the first search that creates results in table 1:

href="FMPro?-token=118&-db=subjects.fp5&-Lay=website&-format=SubjectList.htm&Age=6&-Find" target="mainFrame"

The webpage for table 1 has the following form that creates a link in each record:

<input type="hidden" name="-db" value="assets.fp5">

<input type="hidden" name="-format" value="searchresults.htm">

<input type="hidden" name="-token" value="[FMP-currenttoken]">

<input type="hidden" name="-lay" value="websearch">

<input type="hidden" name="qty" value="1">

<a href="FMPro?token=118&-db=assets.fp5&-Lay=websearch&-format=searchresults.htm&subject=[FMP-currentrecid]&-Find">

View a list of clips featuring this subject</a>

</p>

</td>

<td valign="top">[FMP-Field: Subject]</td>

<td valign="top">[FMP-Field: Age at shoot]</td>

<td width="99" valign="top">[FMP-Field: Ethnicity]</td>

< </tr>

<tr>

<td width="105" height="2"></td>

<td width="137"></td>

<td></td>

<td></td>

<td></td>

<td width="99"></td>

</tr>

<tr>

<td height="3" width="105"></td>

<td width="137"></td>

<td><img height="1" width="322" src="/spacer.gif"></td>

<td></td>

<td></td>

<td width="99"></td>

</tr>

[/FMP-Record]

what am I doing wrong?

thanks for all your help people!!

RE: The webpage for table 1 has the following form that creates a link in each record:

There are 2 things in HTML.

Form

URL link.

You cannot mix them together. One doesn't know about the existence of the other.

HTH

Lance,

This is what I would do to fix the current problem:

<a href="FMPro?token=118&-db=assets.fp5&-Lay=websearch&-format=searchresults.htm&subject=[FMP-Field:Subject]&-Find">

---

I think the form is not necessary. You could also look at using Javascript to 'clean-up' a bit.

Hope this helps.

Garry

Garry,

Thanks so much! That worked!!

Lance