AnsweredAssumed Answered

Portal Filtering

Question asked by ShanaEichleberger on May 16, 2012
Latest reply on May 16, 2012 by philmodjunk

Title

Portal Filtering

Post

I am very new to filemaker and am having an issue. I would like to filter a portal but I need it to check four different fields. 

I have a table in which its a vehicle report and each trip log as a job number assigned to it. I would like to pull the related trip logs to another table by the job numbers matching. However I need to check four different fields for the job number.

My code right now is: 

Case(Daily Vehicle Reports::Job Number1=Job Cost Sheets 4::Jobnumber;) or

Case(Daily Vehicle Reports::Job Number2=Job Cost Sheets 4::Jobnumber;) or

Case(Daily Vehicle Reports::Job Number3=Job Cost Sheets 4::Jobnumber;) or

Case(Daily Vehicle Reports::Job Number4=Job Cost Sheets 4::Jobnumber;)

 

My relationship is set up with Job Cost sheets 4 related to Job Number1, Job Number2, Job Number3, Job Number4.

 

But this will not filter like my other portals.

Outcomes