ValueListChecked

[Garry Claridge]

We are trying to use ValueListChecked with a repeating field. However, only the first repeating item is being recognised as the checked 'Checkbox'. Is there a way to have all corresponding values checked for all repeating items?

Thank you.

Garry

[Keith M. Davie]

1a. The use of repeating fields is not the best design approach.

1b. All repeating fields can be displayed for a given record.

2. Chances are you can avoid the use of the clumsy (and imo virtually useless) ValueListChecked by using standard html with a reference through cdml to a field which is in your web layout formatted as a standard field.

[ July 07, 2001: Message edited by: Keith M. Davie ]

[Garry Claridge]

Thanks Keith,

Whilst I'm a bit of a relational purist, I learned to appreciate the limited usefulness of multi-valued fields when I was developing in Pick (Prime Info) in the mid-80's. They are OK for fields which have a limited number of possible values e.g. less then 5 and the values are from a predefined set. They are handy for values such as phone-numbers.

In this case the repeating field is used for sports a person participates in. The reason we use a value list is so a 'pop-up list' search can be more effective and friendly (for not-so-smart users).

This is how we have worked around the problem:

<td><script>

fldvalue = "";

[FMP-Repeating: sporting]fldvalue = fldvalue + "[FMP-RepeatingItem]";[/FMP-Repeating]

[FMP-ValueList: sporting, List=vlsports]

document.write("<input type='checkbox' name='sporting' value='[FMP-ValueListItem]'");

if (fldvalue.match("[FMP-ValueListItem]")) {

document.write(" checked>[FMP-ValueListItem]");}

else {

document.write(">[FMP-ValueListItem]");}

[/FMP-ValueList]</script>

</td>

[ July 07, 2001: Message edited by: garrycl ]