Sum total, portal, or calculation questions

[dtruog]

Hello,

I apologize if these questions have already been answered. I searched but I have a feeling I'm using the wrong keywords. I haven't used FMP in about 3 years and am finding it hard to add these two new features to existing databases.

1.) I have a portal set up inside a database. Can I make a field that will show me the number of related records currently in the portal? This is being used to show how many tapes (from an inventory database) are related to a certain job number. It would be nice to just have the number handy, instead of having to scroll through the portal and count.

2.) I have a database of my friend's instruments. Each record has a "total worth" field showing a dollar amount. Can I make a field to show the total sum of all of the "total worth" fields? He has over a hundred instruments and I can't figure out where I would put that field. Do I need to make a new database file, reference the "total worth" field, and then do a calculation script?

Any help would be appreciated. Please let me know if anything is unclear.

Thanks for the help,

Dan

[bcooney]

1) in Parent table, create calc, count ( relationship::primarykey)

2) summary field, total of Total Worth. Be careful here, summary fields total the found set of records. So, be sure you have the proper found set.