How do I get the UIDs to show the related names?

[adam999]

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

[Garry Claridge]

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

Garry

[adam999]

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

[Garry Claridge]

Re: Can you have multiple fields in the portal?

Yes.

Garry

[adam999]

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