I am sure this is something simple but I am scratching my head
I have a portal which shows parts used by engineers on a job. The relationship is between the jobs table and the parts table and is linked by job number.
I can get it all working fine when the portal is filtered on job number alone. But now I want it to also to filter only jobs with the same number but when the filed Usedrequired is set to used.
I have set the filter to:
Parts::JobNO & Parts::UsedRequired = "Used"
but this does not work. Can the filter only be applied to a single field or is my phrasing off?