Creating functions in a Home Layout from a separate table.

[scchoi]

Edit: Sorry but I realized this might be more fitting underneath the functions section of the forum... my apologizes.

Hello FM Forum,

Long story short, I'm fairly new to FileMaker and I'm trying to create a database from scratch. At the moment, I have 5 tables. Stamp, Album, Type, Collection, and Home.

For my layouts, I have a Stamp_List, Stamp_Detail that are based off of Stamp table, Album_List that is based off of Album table, Type_List based off of Type table, and Default_Home (which is basically an utility layout that is based off Home table and has no fields at the moment)

What I want to do is create a function to counts the total number of records in the Stamp table. That is my database is a collection of Stamps and I want the default home page to show that number of records.

Previously, I used the Get(TotalRecordCount) when my Default_Home was based off the Stamp table but I figured that wouldn't be in my interests when I need to do other stuff for default_home.

In addition, I would like to add a field or function where I can see the total value of the stamp collection. (this is another field within the Stamp table) and create a chart for the Types of stamps (a field in the Type table).

I'd greatly appreciate your inputs on the best approach to these scenarios!

Thanks,

scchoi

[bcooney]

Home::Count_Stamps = count ( relationship::StampID)

Home::TotalValueStamps = sum ( relationship::Stamp_Value)

[scchoi]

Hi Bcooney, I've tried that but my field is not producing any answers. Perhaps my relationship is wrong? Can you critique my relationship. I posted a screen shot of the relationship below.

I'm displaying data from Home::Count_Stamps and the calculation field is Count ( HOM_Stamp::__kp_StampID )

Best regards,

scchoi

[bcooney]

You do not need _kF_Stamps in the Home table. Since you are counting all stamps (and not filtering) you can use a Cartesian join between any two fields in Home and Stamps ( x relationship).

[scchoi]

The cartesian worked! thanks!