Populating value lists from several fields

[Jarvis]

Is there a way to create a value list using the values from as many as 10 different fields?

If anybody can help me here I sure would appreciate it.

Thanks,

Jarvis

[Vaughan]

Create a calculated field that is a paragraph-delimited concatention of the fields:

field1 & ¶ &

field2 & ¶ &

field3 & ¶ &

field4 & ¶ &

field5 & ¶ &

field6 & ¶ &

field7... etc

Base the value list on this calculated field.

[Jarvis]

Thank Vaughan.

I was able to generate a list of these values but could not select

any particular value from the list.

Any ideas how to make this happen?

Jarvis

[Raybaudi]

Maybe your calc gives a "number" result ?

BTW: try this

VLfromMultipleFields.zip