Value List based on multiple fields

[SNIhrig]

I want to create a value list that includes values from multiple (six) fields into one list. The "Use values from field" option only allows up to two fields. Any suggestions on the best approach to achieve this? Thanks.

Scott

[IdealData]

You need another calc field. Say "AllFields", where "AllFields" is a string concatenation of each of the fields required, but each separated by a "return".

Here's the calc I used to test with:

"AllFields =

f1 & "