relationships using calculated fields

[grinducci]

I have a master file (MAccts) with an owner field with 3 values, an Accounts (Accounts) file containing user accounts. Among others, the Accts file has the MAcctNum, AcctNum, Owner field and a Type field. One relationship is based on a master account number (MAcctNum) present in both DBs. When I display a portal on a layout in the MAccts file, all the related accounts to the MAcct show up fine.

Now, I want to display subsets of the accounts, based on the category of the account and its owner, on a single layout. I am putting multiple portals on the layout in MAccts and trying to set up separate relationships between MAccts calculated fields and Accounts based on calculated fields that aggregate the <MAcctNum> + <Owner> + <Type> into a separate calculated field in Accounts. These are realted to similar field values created in MAccts. I'm using text type fields for the results, they are indexed, and I'm getting the expected results to the calculations. However, the results displayed in my portals are not working, I get the same output to the portal (repeating the same account in multiple lines) and it doesn't correspond to the filtering of the relationship designated for that portal. I've even changed relationships from one to another and still gotten the same info displayed in the portal.

I've even gone to hard entering match data in text fields, avoiding the calculation all together and still can't get this to work. Any help would be greatly appreciated. Thx in advance, Steve

[Ender]

>> I get the same output to the portal (repeating the same account in multiple lines)

Check that the fields in the portal, and the portal itself are from the correct relationship.

[grinducci]

Thx, Ender, I wasn't aware that both had to be derived from teh realtionship, not just the portal. - Steve

[Ender]

>>I wasn't aware that both had to be derived from teh realtionship, not just the portal.

In FM7, this is no longer the case; you can show fields from related tables other than the portal's. This makes portals even more powerful (and possibly more confusing.)