I am trying to make a search form that will show the results of an input that searches a list within each record.
I have a Data Type that contains a list of grain.
The edit form I have a field that stores a list (as was shown in the shopping cart tutorial), except I use a dropdown that is populated from the first table to select the items for the list.
The lists are showing correctly when I look a the main results on a detail page and in a repeating group.
What I can’t figure out is how to perform a search based on a specific grain. I see that the record stores a unique ID for each instance of each item in the list, so I’m at a loss.
Here is the seach form that I’m working on.