Aren't you making it more complicated than it needs to be? As presented you have XX colours but only 2 textures and 2 shapes—but this translates into 4 possible combinations for each colour, so a calculated list could get quite long, and then you'd have to parse the selection back to the original fields somehow. To miy mind it would seem easier to simply present three choices: colour (which could be a drop down list if there are lots or if the list keeps growing), texture and shape, each of which could be radio buttons making selection obvious and very quick.
Right you are.
I know I can make conditional dropdown lists. But, it occured to me to inquire if I could get the 2nd and 3rd fields to auto populate given the selection from the first.
I couldn't see a way to easily do it and was wondering if anyone else had run across a tecnique.
Thanks for replying.
What is the 'trick'???
Your lookup tables should (like every table) have an ID; use that to define your value list. See attached file.
Having posted that: keywords is right; this list becomes quite long pretty quickly, and then it's more work “parsing” it visually to find the desired entry.
If you store each possible combination anyway, then a separate value list on each field should be faster to work with – and you wouldn't need that lookup table.
Of course, if you want to constrain the possible combinations, then you do; but you may want to think about different selection methods.
PopAndLookUp_eos.fmp12.zip 69.1 K