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?