Lets say I have table and one of the records is a list called FOOD LIST.
And I want to find all records where any item in their list is APPLE and bring up that record(s).
Please remember that I am talking about a special SEARCH. I know lists are associated to main records when they are added. But what about the searching for the records based on items in a list that is contained within the record.
FOOD LIST: Mango, Rice …
FOOD LIST: Apple, Rice, Cheese …
FOOD LIST: Apple, Pasta …
I want to return a list of Meals that have APPLE in the list of foods.
So, when I add a food item for a meal, I need to add the record unique ID of the meal record, so I can later fetch each record using unique IDs found, correct?