
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 13, 2020 09:00 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 14, 2020 11:43 AM
Just to understand better, both will be in the same record (row)?
If so, you can make a formula in a new field that is something like IF(field1=field2, Field1, 0)
