Can you post the conditional format expressions here and document any tables/relationships involved?
I doubt you need any such special scripting support for this.
Well, I've been trying all kinds of things to figure this out on my own, but still can't get it to function correctly.
The Main Menu is based on an Admin table that hosts the Help Menus and other things, but no actual records. As I said, it's just for navigation, notification, and storage. All records are in two primary tables (Activity and Issue). I also tried hosting the Main Menu in both of the other tables, but there was no change.
Admin Activity Issue
ActivityID_PK :: ActivityID_FK
The Conditional Formatting on the button on the Main Menu is:
Formula is IsEmpty ( Activity::ApprovedBy ) and to change text color on the button.
Clicking the button takes the user to a list/find layout that lists all Activity Records awaiting approval with a button to go to each record on the list. All that works fine, but the darned button on the Main Menu returns the text color even when clicking on it takes the user to an empty list. In the table view of those tables, all ApprovedBy fields have data in them, so none are empty.
Put the related field Activity::ApprovedBy directly on the Admin layout. I think that more than likely there will be no value.
From what you stated, you have an additional criteria in the script that the relationship does not; being "Records waiting approval". The relationship just returns all the related activity records.
Yep, I see what you're saying now. I was using conditional formatting all wrong.
Back to &*^$? drawing board!
You appear to have this relationship:
Admin::AdminID_PK = Activity::AdminID_FK
Is that correct?
How do you control what value is in AdminID_PK?
For a quick test, I'd place a portal to Activity on the admin layout that displays the ApprovedBy field to confirm you have the values you think you do. Your description of the problem suggests you might have a different value in AdminID_PK than you expect.