My application has several Select components which the user can use to enter information. The first two fields have only a small number of options. The third field has over 70 options and can be tedious to use.
I want to use the values selected in the first two Select components to filter the available options presented to the user in the third Select.
The options in the third select are pulled from records in the base. These records have linked fields. Some of these linked field values are options chosen in the previous Select components.
So, lets say I want to filter returned records from a table where values in a linked field (s) match either the record ID of string value in said linked field.