Two Value Lists, one field

[fperugini]

Greetings All,

I have a need to populate a single field from either one of two value lists. (I did not want to use one dynamic drop down list)

Are there any tricks anyone has used to achieve this effect. Here's how the layout would look:

Field |____________| button to drop list 1 button to drop list 2

I can make the two buttons above the same field as the destination, and attach the different value lists to each one, but I can't think of a way to make it look visually appealing and intuitive. It would then dispaly the same choice 3 times.

Any help would be greatly appreciated as always.

-Frank

[John Caballero]

I don't know if this will work, but give it a try:

On top of your "button to drop list 1", place a copy of your target field, making sure it is transparent. Format it to display value list 1. On top of "button to drop list 2", place another copy of your target field, transparent, formatted to display value list 2. Since the fields are transparent (no borders, btw), what your users will see is what you described. When they click on what they think is one of the buttons, they'll actually be entering the "invisible" target field copy and will see one or the other of the value lists depending on which button they think they've selected. If your buttons actually have scripts attached to them, we'll have to think of some other solution as the button(s) will never be clicked because there's an invisible field in the way.

[Ugo DI LUCA]

Have a look to this tip file

MultipleValueLists

It also gives access to different related lists, which you won't bother with.

You could just stack the fields one over the other and have the exit script pick the correct value list.

[Ugo DI LUCA]

Attached modified version.

MultipleVList.zip

[fperugini]

John,

Thanks for the quick reply.

I sort of have it working...not quite perfect. What do you mean by transparant?

Now I have a darn tab order problem! I need to find a way to prevent the list that does not get selected from dropping down.

Is there any way to exclude a field from the tab order?

Any tips?

-Frank

[fperugini]

Thanks Ugo,

Upon initial checking, it works, but is kind of slow, and not quite the effect I wanted to achieve. I am going to play around with it for a while...

-Frank

[Ugo DI LUCA]

Franck,

Here's another version where the final previously selected name disappears from the list.

The Pause is set to 1 sec, and it would naturally be quicker as it wouldn't require the script to check which "relationship" to bring back.

Also, the script could be launched by another button at right of the field if needed.

Create new records to see the message brought into the first field.

It was auto-entered first, it's now a new field.

MultipleVList.zip

[fperugini]

Thanks again.