Jump to content

Two Value Lists, one field


This topic is 7496 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.


Link to comment
Share on other sites

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.

Link to comment
Share on other sites


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?


Link to comment
Share on other sites


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.


Link to comment
Share on other sites

This topic is 7496 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.