Hi can anyone advise how i can make a simple value list conditional?

I have a single table on a job bag system and one field specifies the choosen print supplier i.e.: "London Print ""Wards Print" etc.

I would like the detail fields such as "Foil Colour" to be conditional because different suppliers have different references to the colour swatches.. e.g. London Print may use "RED032" where Wards Print could use "BlazeRed"

I only want to display the user the values specified by the choosen supplier..

i'm not sure where to start? I think i need to create tables and relationships but would appreciate any help thats out there on the forum... many thanks

Hi beckham,

This need comes up from time to time. Here is a recent thread that may help.

https://fmforums.com/topic/99647-category-and-sub-category/#comment-453607

I linked to example files to this link.

Let us know if this isn't what you meant.

Lee

Thank you Lee i found the you tube link earlier and another one by Guy Stevens but didn't understand how to relate those examples to my file.

Your example file is most useful i will check that out in detail.

kindest regards..

Following Lee's advice i have succesfully managed to create a conditional value list, but i have have a strange problem.

The conditional popup menu (or drop down) is very slow at propagation of value i.e.: the list that matches the condition can take minutes to load or change based on the trigger condition... any idea how i can speed this up?

Thanks...

Answer to my own question, I found an error in the setup i failed to identify the "include only related values checkbox"