I've come close, but... Trying to highlight a portal row in File 1 only when a field in the current record in File 1 (call it Job) matches the data in a field in a record in File 2 (Call it Text).
The Job file has a Text portal. The only records that display from Text are those for which the first word in the Job_Name field matches the first word in Text_Name records via a relationship:
so the portal shows matching records from Text:
ABC Record 3
ABC Record 4
but not CDE Record 2 in Text.
This works fine. However, this relationship can result in a listing of zero to over a dozen records in the portal. Users often do need to see that whole list. But it would be very helpful if I could highlight a couple records for which another field, "J_Dimensions" in Job, exactly matches the "T_Dimensions" field in Text.
ABC Record1 ...in Text
ABC Record 3 ...in Text (Highlighted because Dimensions fields in Job and Text match)
ABC Record 4 ...in Text
I've played around with conditional formatting (which didn't get me too far), and with a second relationship between the two files based on the Dimensions field, and a gColorFlags field (repetitive field with various colors), and the use of a "Flag Display" field with a calculation and the calculation result as Container. (If JobsDImensions = TextDimensions, GetRepetition(gColorFlags; 7)...
I know just about anything except world peace is possible via Filemaker, and I thought I could figure it out, but I keep getting tangled up--especially over which fields go where--and I'm going in circles. Help?