AnsweredAssumed Answered

Portal filter (filemaker 10)

Question asked by Mastema on Oct 6, 2010
Latest reply on Oct 7, 2010 by Mastema


Portal filter (filemaker 10)



I'm trying to create a filter for a portal, but I seem to be stuck:

i've got two tables (view an company)

table view:

"prospect" as a number (0 or 1) global field
"one" as a number (global, always 1)
"companyfilter" as a text (global)

table company:

"prospect" as a number (0 or 1)
"name" as a text
"calcFilter" as a calculation field ( PatternCount(name; View::companyFilter) ≥ 1), result is number (this works fine)

If i make a relationship: view::prospect = company::prospect everything works fine: after changing the value of view::prospect, my portal view only shows the ones that match

If i make a relationship: view::one = company::companyfilter, regardless of the previous relationship, no information is shown in my portal when I change the value of companyfilter...
Does anyone know what i'm doing wrong?