2 Tables Recipes & Fruit. There is a relationship between Recipes & Fruit. Each recipe has a number of fruits.
1) The user will selct different fruits via a script in List View which will be assembled into a global variable $$fruits
2) There is a calculation field in recipes List(frecipes::fruits)
So I would like to return a list of Primary Keys from Recipes that have the selcted $$fruits.
So Recipe 1 may contain
$$fruits may contain
So $$fruits meets criteria. I would like to have a sql statement that assmbles the Recipe ID's across the total set of records. I was able to accomplish this with custom functions; but I didn't like the performance. Thanks so much for all the help!!!