using the portal filter properly
Hi, I am having difficulty with portals.
in my database I have 3 tables, the main dtabase, the model to contacts table and the contact information table
so the main database is linked to the model to contact table via PI_fk and the model to contact table is linked via Ci_fk.
and in the model to contact table, there are 3 fields, called PI_fk, Ci_fk and the contact_type which is either vetter or owner
so for the portal in the main database, i set filter on the portal to show only when model to contact::contact_type = "owner"
however, It will show all the contacts from the contact information table regardless of whether iti s owner or vetter as long as the first contact in the contact info table is 'owner'
what am i doing wrong? this is confusing.