AnsweredAssumed Answered

Spider Web

Question asked by Gilo on Mar 17, 2015
Latest reply on Mar 17, 2015 by Gilo

Title

Spider Web

Post

Hi

I have a hudge chaotic relations web, which seems to cause me some problems. Here is my setup

client ----< household (based on clients)

where client:adress = household:adress

client ----< household ---< contracts

where household:client_ID = contract:contract_client_ID

So FM shows me on my client layout all contracts from the household, the client's from. Works perfectly. 

But I need now a field client:check, which gives me back

1, if there is one or more "Premium" in contract:contract_type
2, if there is one or more "Gold" in contract:contract_type
3, if there is one or more "Normal" in contract:contract_type

I have a layout, based on clients, with a portal based on contract and it shows me all contracts of the client. But my field only checks the first line of the portal. If the 3 or 4 portal line has "Gold" it ignores it. Why is this? How can I solve this problem?
 

Outcomes