Can someone explain the basics of what I want to do here?

I have a table called "Tools". I want to set each tool to a location which can be one of 3 places. A jobsite, a truck or a location in the shop. All of which have their own tables.

I want to have a pull down menu 2 choose one of the 3. (Shop, truck or job)

Once that's chosen, I want the next field to show options from the first. Example: From the pull down menu, if your choose job, the next field will be another pull down menu of the jobs. But if you choose shop, the next field will change to locations in the shop.

I am picturing using a script trigger with this but not sure how to get the second field value list to change.

Thanks in advance

Do an advanced search for +conditional +valuelist

Why aren't all the locations in the same table? That would make this (and maybe other issues) much easier.

The way you have it now, I believe the only way it can work is to stack three instances of the same field on the layout, each with its own value list, and have the script go to the correct instance according to the previous selection.

I am adding to an existing solution. This database is very large and complex to rewrite for this feature.

If you use a menu plug-in (i.e. Dacons MenuControl), then you can script the appearance of a popup menu in the right location. Choosing an option from that menu will invoke a new script. The field could be formatted to look like a popup field, but still be a normal edit box, input disabled and with a button control attached to it.