Create a Value List from data in a Repeating Field

[Ja5en]

Hey all,

I'm sure this has been answered a dozen times or more, but how do I create a Value List from data in a Repeating Field?

Scenario: Its a repeating field of up to 10 colours, I want to then be able choose 1 of those colours from a drop down list .. but only choose from the values of repeating field of the current record, not all of the records in the database.

Any tips would be most welcomed. Thanks J

[mr_vodka]

You will need to create a self join keyed on your primary ID. Then reference the repeating field of the Self Join.

However, I must warn you that using repeating fields usually means that you probably have a relational structure issue. Why are you using repeating fields?

[David Jondreau]

It's been answered hundreds of times. And the answer is...don't use repeating fields!

Edited February 26, 2009 by Guest