Jump to content
Sign in to follow this  
Andrew5

How to show portal summary data elsewhere?

Recommended Posts

How do I show a portal's summary field on the layout of the parent table? When I put a portal summary field in a layout of the parent table it gives me the the summary of the related record only.

Share this post


Link to post
Share on other sites

Not sure what you are getting at...

If you put a summary with from the same TO relationship that your portal is using, then it will sum up all the related records that are reflective in your portal.

Share this post


Link to post
Share on other sites

It is a checkbook program. On one day there can be 1 up to 6-7 payments made, so I made a portal as there is only one deposit each day- one deposit (parent table) with several payments made that day (child table). The parent table holds the date, memo, and some other info. The child table holds the dollar amount, customer name, and a key (of course). I want to create a summary field for all of the deposits, a total of all deposits. I can do that if I display the total on a layout based on the child table, but if I insert the same field onto a layout based on the parent table, the once a day deposits, that field will only give me the total of the deposits of that day-- so how can I display the total of all deposits on a layout based on my parent-deposit table? Whew...!

Share this post


Link to post
Share on other sites

Again, it will only show you the sum of the related records that are displayed in your portal.

If you want a total for all the desposits, then you wil need a self join. Another poster asked basically the same question yesterday.

http://www.fmforums.com/forum/showtopic.php?tid/195873/post/293241/#293241

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.