3 Checkboxes with scripts to find 2 or more matching values from 3 different fields.
Apologise if my title didn't make any sense.
The aim is to create script(s) which will find all the values ticked from 3 different check boxes.
Let’s say I want to find the records matching to the following by clicking the values in check boxes:
“Vegetable” and “Fruits” from Produce category and
“UK” and “France” of origins and
“Fresh” and “Frozen from State of the products.
to show the record(s)match to above criteria.
However, I may only want to tick just 1 value from 1 checkbox, to just find "apples" only from Produce category.
These are the fields I have so far:
GROCERIES::Produce (apple, peas, pear, basil, potato, etc…)
GROCERIES:: Type (Fruits, Vegetable or Herbs)
GROCERIES::Origin (UK, France, Spain, etc..)
GROCERIES::State (Fresh, Frozen or Dried)
I also created 3 global fields, which are the checkboxes listing all the values from the appropriate fields:
GROCERIES::g_finf_produce, all values from the field GROCERIES::Produce
GROCERIES::g_find_fuits, all values from GROCERIES:: Type
GROCERIES::g_find_origin, all values from GROCERIES::Origin
How do I create a script that finds everything that I tick from each of the 3 check boxes and which field should I attach the script to?
Should I make 3 different scripts and apply to each global fields or should I make just 1 script and apply to all 3 global fields?