List Boxes and New Records Via A portal

[DSTUART]

Ok Two questions the first to do with drop down list boxes:

In filemaker you can create a value list with two values in it e.g. an Id and the name of the person it is assoicated to. How can this be accomplished in cdml?? I have managed to do it but it involved populating javascript arrays and then the list box is there an easier way.

Second question I am trying to create a form to insert a new record via portal (so it assoicates but I keep getting a 102 error (fields missing) do I have to have all of the fields that are in my layout in the form???

Thanks for youe help

D

[Garry Claridge]

2. You need all of the Fields in the Form to be on the Layout. Including the Related Fields in the Portal.

1. I wrote one of these some time ago and posted it here. It uses a Calculated field which concatenates the required fields with a delimiter, then uses a small amount of Javascript to separate and place in the Select.

All the best.

Garry

[skuli]

Concerning question 1, you could also do as Garry said and make a calculation in FM that puts the two values into one string and but then set the name value to only one of the fields. The following does exactly this as I wanted the user to be able to associate a project number to its name, but only wanted the project number entered into the field.

<SELECT NAME="ProjectNumber">

[FMP-InlineAction: -db=Projects_SF_.fp5, -lay=Table, ClientNumber={CurrentToken:1}, -Max=All, -Find]

[FMP-Record]

<option value="[FMP-Field:ProjectNumber]">[FMP-Field:ProjectNumberNameCalc]

[/FMP-Record]

[/FMP-InlineAction]

</SELECT>