so i have multiple Layouts that are related to one another in some fashion.
Well layouts are not related, tables are related to one another via Tutorial: What are Table Occurrences? in Manage | Database | Relationships. That may sound like I am being picky, but this is an import conceptual detail to keep in mind. After all, you can have two or more layouts that are based on the same table via the table occurrences selected for them in "show records from" in Layout Setup...
It seems like you have this relationship:
PO::Style Name = Product::Style Name
You shouldn't need to change your relationship to get this color change.
Just right click PO::Style Name while in layout mode and select "conditional Format".
Add a new conditional format with this formula:
Product::Cutting = "yes"
Select a fill color for the field and you should be done.
you are correct. sorry. i need to be more specific on that.
i tried what you said. makes complete sense. i didnt know that you can do formulas in conditional formatting. however, this didnt work. nothgin happened.
It's a method that I frequently use. Let me know exactly what you did and exactly what results, if any that produced.
My suggested solution assumes that:
Cutting is a field of type text.
Cutting only contains single values. There isn't, for example, a set of checkboxes where "yes" is just one of the values entered into the cutting field.
i like it and will use it from now on!
you are correct. Cutting is a text field. and i type either yes or nothing in it. i am not using checkboxes.
i did exactly what you said in the conditional formating and when i loaded the info, nothing happened at all.
That's why I asked you to spell out exactly what you did, step by step.
Try this, capture a screen shot of the conditional format dialog for your field. Use the upload an image controls below Post A Answer to upload that image here. (Make sure to have the correct file type or the image won't appear after you upload it.)