Value-list appearing when needed???

[gumstic]

What i'm trying to do here (if its possible), is to create a hierarchical value-list (selecting the 1st-level releated to 2nd-level etc.) that when a you select the top level value-list, then the 2nd-level which is related to the selection made in the 1st-level value-list, should appear on the current layout. The rest of the value-lists not matching should be hidden from the layout.

Is this possible to do?

Thanks

[Vaughan]

Yes. They are called "conditional value lists" and they rely on related files to get their data to display correctly.

Definately one to look up in the manual or on-line help if you are not sure. Also check the sample file section, somebody may have posted a demo.

[gumstic]

Well, maybe i wasnt clear with what i mean...

Example: Value list one - red, green, blue

Related value list for "red" - red roses, red peppers, red apples

Related value list for "green" - green peas, green peppers, green grass

Related value list for "blue" - blue sea, blue sky, blue eyes

Now when you select Value List One - "red" normally the next field should give the related value list for "red" Nice up to here.

What i'm asking is something like when the "red" list is selected then the related list (red roses, etc..) apear "dynamically" in a field below and the same should happen if some other selection is made of any other list. This is to spare some space in a portal row. Like for ex. if i had 10 basic value lists and 5-6 related value lists for each of the basic 10, then space is not enough so if there is a way to spare space and use or re-use the same field for multiple related value lists. Note that in this case not all 10 basic value lists could ever be selected in one portal row, so the the re-used fields could be 5 or 6.

Thanks

[danjacoby]

You're still not clear, perhaps because you're misusing terms.

A value list is a list of values. What you want is one related value list for each possible main item.

The problem occurs because you're not clear on just how this list should appear.

Do you want the list to appear automatically as the contents of the second field? If so, make the second field a calculation field, and have it return the calculated result based on the contents of the first field.

Or do you want to be able to choose a value for the second field from a dynamic list, based on the contents of the first field? If so, then Vaughan's answer is exactly what you want (he really deserves far better than his 3-star rating!).

[gumstic]

Yes its your second suggestion Dajacoby! So i was not clear enough about it and Vaughan's answer was right.

I got the trick working with an example.

Thanks all.

[gumstic]

Something more...

How can the conditional list work in a portal row?

I tried a few variations but without luck.

If there is a way, please help.

:-)

[Pupiweb]

Quite possible

The basic steps are:

- create the conditional value lists in the *related* file

- in the master file create the same number of lists, setting them to "use a value list from another file" and choosing the appropriate one in the related file

HTH