Creating a Portal Index With QTY from another table

[NateBBB]

I have three tables:

A: Casino Names

B:Slot Machines Inventory

C.Game Types

Relationship A to B: a casino can have many games

Relationship B to C: a game type can be on many games

Keys

Table A: Casino Name (1)

Table B: Game's Location (1) & Game Type (2)

Table C: Game Type(2)

I would like to make a portal on the CASINO NAMES Table.

I can get the portal to show all the games at the casino (i.e)

[Portal]

Row 1. Cash Gold Asset# 54

Row 2. Cash Gold Asset# 56

Row 3. Money Magic Asset # 58

Row 4. Green Cash Asset # 89

Row 5. Cash Gold Asset # 90

Row 6. Green Cash Asset # 88

But I would like the portal to show for a specific casino's games.

[Portal]

Row 1. Cash Gold Total 3

Row 2. Money Magic Total 1

Row 3. Green Cash Total 2

How do I do the Total Calculation? How do I create the above portal in casino names layout?

Thanks

[comment]

This is very easy to do in a report with sub-summary parts - but quite difficult in Browse mode. See:

http://fmforums.com/forum/showtopic.php?tid/198526/