I have a Event::Cwarnings field that is a calculation based on different things like event status in relationship to the end date. for example, if the event is over and not invoiced or paid, returns a warning that says "not invoiced."
If there are no warnings and the field is empty.
I want to create a table relationship with the user homepage where
User::User ID = Event::Account Manager
(?unknown field representing a non value?) does not equal Event::cWarnings
I was able to do this with User::User ID = Event::Account Manager and filtering the portal but the performance is lacking because there are many event records to filter.