portal filtering: help with an IsEmpty calculation
Products is a table in my database and Designer is a field in that table. From my Products table I have a portal to another TO of Products, Products2.
I'd like to filter out the records from this portal that have a blank Designer field, so only the related records with text entered in the Designer field appear in the portal.
Can someone help me with the calculation to achieve this? I'm assuming it has something to do with the IsEmpty function, but I can't quite figure it out.
Thanks so much!