I am able search a portal on Layout1 using an HTML option list which hides a unique identifier but shows a related value list as in the following code:

<SELECT NAME="Portal::Field" > <!-- On master database -->

<OPTION VALUE=""> - No Selection -

[FMP-InlineAction: -db=Related.fp5, -lay=Layout, -findall] <!-- Items in other DB -->

[FMP-Record] <option value="[FMP-Field:UniqueID]">[FMP-Field:TextName] [/FMP-Record]

[/FMP-InlineAction]

</SELECT>

This searches the unique ids entered into the portal correctly. Another DB keeps track of the joins.

I have the records formatted as URLs using currentrecid to take you to Layout1. How do I now show the entries in the portal as their related names instead of the ID.

Many thanks

Adam

Have you added the Name field to the Portal in the Layout?

Garry

No. JobID (a field in the join database) is placed in the portal. This is formatted as a pop-up list using a value list from another database that shows the JobID and the JobName. After the selection the name isn't shown. Can you have multiple fields in the portal?

Adam

Re: Can you have multiple fields in the portal?

Yes.

Garry

Garry,

Thanks for the clue. A basic (?) design issue from the manual! I created a calculation field in the join file and placed this field into the portal.

Many thanks,

Adam