Dynamic query for multiselect field?

Say we have a catalog of:

  • Cats
  • Dogs
  • Mice

Then I have a structured field where the user can describe connections:

  1. select Type of Connection (Cat, Dog, Mouse)
  2. multiselect Select the correct animal
  3. textarea Describe the connection

Is there any way for the multiselect query to reflect the option selected in #1? Or is the only way to achieve this by creating separate fields for each type of animal and using when to show/hide them accordingly? (this would get very long winded on larger lists of possible selections, and also I assume the multiselect field name needs to be unique?)

As a quick side question, what really is the difference between the tags and multiselect fields? For some reason I’m finding multiselect to have a long delay when loading a large list while tags is very responsive.

No, since one field doesn’t know anything of the other, querying the result of No.1 would require you to first save the content, and then select from the results.

I think the only feasible way would be to create custom field that listen to the other field client-side. There is a similar topic somewhere here, just have to find it.

This is the one I meant: Programmatically change the content of the file field - #18 by VECT0R