Filling a field with a color if a separate field in another Layout reads "yes"
so i have multiple Layouts that are related to one another in some fashion.
i have a field in one layout (PO) called "Style Name" that relates to the "Style name" field in another Layout (Product).
I created another field in 'Product' called "Cutting."
id like to fill the PO-Style Name field with a color if the field "cutting" contains "yes" in it.
can i relate one field (PO-Style name) to two seperate fields (Product-Style Name and Product-Cutting)?