[FP5]

[alopas]

Hi,

Lets say I have:

"ITEMS INFO" with three records, being the field "name" content "A","B" and "C"

"INVENTORY OF ITEMS", related by "name" to "ITEMS INFO", with six records: A,A,A,B,B,C

Can I have a portal in "ITEMS INFO" so it can show and inventory, as follows?

A: 3

B: 2

C: 1

Thanks in advance!

FileMaker Version: 5

Platform: Windows XP

[Ugo DI LUCA]

Hi,

Even if it may work, I'd not recommand it unless all is scripted and all unstored calcs are substituted with index fields.

Just one alternative.

HTH

FileMaker Version: 6

Platform: Mac OS 9

SummaryPortal.zip

[alopas]

Yes, I guess I'll get the info from the first database, with the standard report and summary fields ... thanks anyway!

[Ugo DI LUCA]

Hey,

It can be done. I was just referring to my attachment where unstored calcs would need to be converted to indexed num fields.

Actually, it was made a bit quickly, but you should be able to have this appear rather dynamically and without too many steps.

FileMaker Version: 6

Platform: Mac OS 9