Hi Roger, Many thanks for this thread. We used this to code to show a pop up using a 1toM relatationship between a point feature and a related table. However, it does not show all the related records, only the first. I cannot use the actual data but have mocked up a similar table structure to the one we are working with. Is there something obvious we are missing. Thanks Paul Resolved... var allIngredients = FeatureSetByName($datastore, "Ingredients_all2"); var ingredients = Filter(allIngredients, "Vendor_Nam = '"+$feature["FIRST_Vendor_Nam"]+"'"); var materials = OrderBy(Distinct(ingredients, "Material_N"), "Material_N ASC"); var cnt = Count(materials); var ingredientList = ""; if (cnt > 0) { for(var material in materials){ ingredientList += material.Material_N + '\n'; } } return ingredientList;
... View more