Hi. I’ve made a plant database for designing edible landscapes however I can’t figure out how to efficiently add several filters to the plants in one of the tables in the form called “3)What plants could grow? The Microclimate” For example:
One for the columns is called Shade. The entries are either:
…
F (full)
FS
FS
FSN
S (some)
SN
N (none)
…
when I click “Form-based filters” and enter ‘N’ under the column header “Shade” I see:
…
Or
Shade: ‘N’
…
show up in the filter navigator. I click on the “Or” in the filter Navigator and I can enter another criteria. Say ‘SN’. and now I have
…
Plot_Availability_Characteristics
Or
Shade: ‘N’
Or
Sade: ‘SN’
…
Now I want to return only the plants that have an “Edibility Rating” of 5 so I enter ‘5’ under the column header for “Edibility Rating” and now I have:
…
Plot_Availability_Characteristics
Or
Shade: ‘N’
Or
Sade: ‘SN’
EdibilityRating: ‘5’
…
The problem is that the ‘EdibilityRating’ filter is not applied to any of the plants with ‘N’ for shade.
I a aware that I can click on "Shade: ‘N’ in the filter navigator and then enter ‘5’ in the EdibilityRating column to get:
…
Plot_Availability_Characteristics
Or
Shade: ‘N’
EdibilityRating: ‘5’
Or
Sade: ‘SN’
EdibilityRating: ‘5’
…
However this process is not efficient enough. In the end, I may need to retrieve only plants the have Edibility 1, 2, or 3, Shade N, NS or FSN and perhaps characteristics specific to Soil and even height. Example if I want to return all plants suitable to ‘D’ “Dry soil” I would have to add them to each group.
…
Plot_Availability_Characteristics
Or
Shade: ‘N’
EdibilityRating: ‘5’
Soil: ‘D’
Or
Sade: ‘SN’
EdibilityRating: ‘5’
Soil: ‘D’
…
If I wanted plants with EdibilityRating ‘4’ as well I’d have to do:
…
Plot_Availability_Characteristics
Or
Shade: ‘N’
EdibilityRating: ‘5’
Soil: ‘D’
Or
Sade: ‘SN’
EdibilityRating: ‘5’
Soil: ‘D’
Or
Shade: ‘N’
EdibilityRating: ‘4’
Soil: ‘D’
Or
Sade: ‘SN’
EdibilityRating: ‘4’
Soil: ‘D’
…
So it is getting exponentially more difficult to add each criteria.
Is there a syntax I can use to do something like:
…
Plot_Availability_Characteristics
Or
Shade: ‘N’ or ‘SN’
EdibilityRating: ‘5’ or '4"
Soil: ‘D’
…
Here is a link to the database so you can have a look.https://drive.google.com/open?id=177ZMBUI9fzW9vo3h1eAoAEa44WBt8OkU