Value lists & repeating fields

[vangar]

Hi Folks,

I have a survey report page, that uses repeating fields and filtered value lists. The first field is used to select a trade, based on this trade selection the second field provides a filtered value list relevant to the selected trade. On the first row of the repeating field this works perfectly.

The problem lies when you move to the next row of repeating fields, instead of the second field basing the filtering of the value list on the first field on this row it, bases the filtering on the first field on the first row.

Can anyone provide any assistance on how I may work round this?

[-Queue-]

I don't believe you can base a conditional value list on repeating fields. There's no way to specify the particular repetition for it, so each one will use the 'default', or first, repetition as the filter.

Why the need for repeating fields anyway?

[cjaeger]

you can base value lists on repeating fields, but: repeating fields in relations are considered like one field containg all entries in return-separaed form (aka multi-key fields), so no filtering on particular repetitions.

[-Queue-]

Meaning that you can't do it, at least not successfully, unless you want a multi-key?