Im a bit stuck on this one

See attached File... I have a portal that show "Alexandria" "Alpine White" etc I want a calculation that returns "Alexandria" = 2 "Alpine White" = 1 "Champagne Pearl" = 2 etc

These name "Alexandria" are dynamic

Any ideas

Thanks

Tim

Canberra

Australia

PotalScreenDump.tiff

One way to do this is to create a self-join of the child table, matching on name and parent ID. Then count the related records (still in the child table) and show the result in the portal.

Hi Comment?

What count do I use...

and also

I may not have explained this correctly

in the attached sample Using Alexandria as the example .. Line 1 Alexandria = 1..... Line 2 Alexandria =2 and so on as more entries are made on Alexandria the count will continue so the 8th entry of Alexandria will show 8

The same is needed for each of the Colour groups (Alpine White, Champagne etc)

Sorry Hope this makes sense

Tim

Hey Thanks

IVE CRACKED IT

You've got to love Filemaker

Tim

Line 1 Alexandria = 1..... Line 2 Alexandria =2 and so on as more entries are made on Alexandria the count will continue so the 8th entry of Alexandria will show 8

That's going to be more difficult - but still, if you define the self-join as:

Child::ParentID = Child 2::ParentID

AND

Child::Category = Child 2::Category

AND

Child::ChildID ≥ Child 2::ChildID

you can then count the Child 2::ChildID field (or any other field that cannot be empty) from the context of Child. Note that this assumes the portal shows the records in order of creation.