Repeating fields validation (example)

[Dusty_Rods]

Hi guys,

Attached is a small example of a problem i have.

1) I a repeating field called designation that has a value list entry. I want to be able to validate that no two repeats of designation is the same. Also i need to validate for the record the retail and commission can never be together in the repeating fields.

2) Secoundly if at all possible that if a use picks retail for the designation for the first repeat of designation that the first repeat of sub designation will acquire the the value list of SubDesignation(retail) - VL this can be any number of the repeat.

so if designation(3) = "trade"

subdesignation(3) will have a pop menu of SubDesignation(trade) - VL

I have tried everything to get this to work and i cannot get my head around, It is central to a solution and i dont have the time to rip it out and use portals. Im really desperate any help would be very muchg appriated.

Thank yoou for looking

D

repeatingfield.fp7.zip

[-Queue-]

See attached.

repeatingfield1.zip