Assume I have 3 tables A, B and C.
A layout based on Table A has a portal of related records from Table B. Each Table B record has a number of related records in Table C. A "particular field" in Table C records is either empty or not empty.
When all of the related records in Table C have an entry in the "particular field" I would like the Table B record that shows in the Table A portal to change colour.
Can anyone give me some guidance?
Thanking-you in advance.