PatternCount in all portal rows?

[JTSmith]

Jobs Table, has a portal to JobVendors.  Job #1 has 3 portal rows, and the vendors have categories (utility, furniture, cable, etc)

 

I have a checkbox set of Needed Vendors: Furniture, Cable, Utility.  I want a calculation that does:

 

If ( PatternCount ( JOBS::needed ; "Cable" ) and not PatternCount ( VENDORS::type; "Cable" ) ; "Need to order cable and/or internet" ; "" )

 

It only does the first row.  Any ideas on how to do more than one row?  I've researched but can't seem to find anything...

 

Thanks!  

 

 

[eos]

Use List(); e,g,

 

Case ( PatternCount ( JOBS::needed ; "Cable" ) and not PatternCount ( List ( VENDORS::type; "Cable" ) ) ; "Need to order cable and/or internet" )

 

On the other hand, this might get out of hand once you need to manage a large number of vendor categories. Consider a programmatic approach, like this one:

JobVendors_check_eos.fmp12.zip

[JTSmith]

Hey thanks, I guess I'll switch my skill level back to beginner...  I appreciate it, I'll make sense of it when I get back to the office tomorrow!