I’m looking for a way to pull the matching record in two fields.
I’m pulling a bill of materials in from our product table so for example it will pull in these records;
8" Black rod
6" Black Shade
10" Box
In another field I’m pulling in all the parts that match a certain attribute for example
6" Red Shade
10" Red Shade
6" Black Shade
10" Black Shade
6" Green Shade
10" Green Shade
I’m trying to create a field that will see that in the example above the 6" black shade is in both of those fields and return that record.