Using 2 ValueLists on one field

[ndveitch]

Hi There,

I have a quick question to ask, well I think it is a quick question. Is it possible to have a feild display 2 different value lists? What I mean is, in my solution I have a field that when a certain value is set it calculates a table to get values to populate a dynamic value list. Now I need to find out if there is a way to display a static value list in the same feild should the other option be selected. 

So in a nutshell: 

If Field A is selected with option 1, then run script to sort table and get values to populate in ValueList A that is used in Field B. 

If Field A is selected with option 2, then Field B uses static ValueList B

I was thinking of duplicating the layout and then just switching between layouts depending on the value in Field A and then depending on the layout would depend on what ValueList is set for Field B. Would this be the easier option or is there a better way to do this?

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Pro 12" to "Value Lists".

 

The General Topics are reserved for discussion of the tools and features that were new with that version of FileMaker, not for how-to questions.

[bcooney]

Kevin Frank has been exploring value list techniques in his blog http://www.filemakerhacks.com. Worth a look.