Hi, I’m on FM 16. I have a table CON__Consultations. In a layout based on that table, I have a portal that displays consultations using the relationship CON__Consultations ::IDpk x con_CON__Consultations ::IDpk.
I’m filtering this portal with a rolldown list of names, using the following filter: CON__Consultations::NameTitleHistory = con__CON__Consultations::NameProfessional.
I have to be able to display all consultations in the portal, in other words to deactivate the filter. So I added the word All to the list of names in CON__Consultations::NameTitleHistory, and then I modified the portal filter to this:
Case(CON__Consultations::NameTitleHistory ≠ "All";
CON__Consultations::NameTitleHistory = con__CON__Consultations::NameProfessional;
CON__Consultations::NameTitleHistory = "All";
con__CON__Consultations::NameProfessional = con__CON__Consultations::NameProfessional)
The first case works fine, but the second case does not work. I can’t display the entire list of consultations. What should I change to this filter? I’m sure there is a simple solution but I’m not seeing it.