ANOTHER QUESTION
I don’t need a dynamic portal, just a set of records to show in a portal with the records filtered by multiple criteria
e.g. ::ProofReady = “No” and ::CaseNoteCheck = “No”
but it then shows no results (even though there are some that meet that)
I can filter one criteria fine but not two so I think I am missing something silly?
Longway round I could make a calc unstored that combines the fields and then filter results to say
::Newlongwayaroundcalc = “NoNoYesMaybe”
Jake
ANOTHER ANSWER
You could do it that way. Have a concatenated field with the values in in the child table. And then in the portal set up dialogue > Filter portal records, enter parent>child field:Conatenated = “NoNoYesMaybe”.
Or without creating the new concatenated field in the portal set up dialogue > Filter portal records enter
parent>child field:One = “No” and
parent>child field:Two = “No” and
parent>child field:Three = “Yes” and
parent>child field:Four = “Maybe”
Martin