Count for Portal field = "text" ?

[RodM]

Parent table is Account table in layout.

Portal shows many "Apples" from my Child1 table belonging to only this account# with several other items , Oranges and Bananas too

Apples, Bananas and Oranges, get populated in Child1 file, from a value-list from a 2nd Child table for all all counts

When looking at 1 account layout, the portal are 3 apples of 5 other items

How might I get an ongoing count of all the Apples, Oranges, Bananas when I relate to a different Parent account#

I figure probably need something like a Count FOR calculation field.

TIA

[David McQueen]

You need a multi predicate relationship:

AccountsTable::Child1Table

AccountID=AccountID

And

Apple = Apple

I have no idea how many different items there may be. For a really limited selection, one relationship per fruit from account and then use a calculation to get the number in the relationship.

For a great number of "Fruit", you might want to set up a script where you systematically set the "Fruit" key in Accounts, grab a count of the number of items and place it into a list. this could activate on changing accounts.

There are probably other ways of getting at this and how you go about it may in large part be determined by the number of "Fruit" you have to deal with and whether or not the "Fruits" change frm time to time or are static.