Jump to content
Sign in to follow this  


Recommended Posts

I have a layout that displays, in List view, a set of Invoices. Invoices are paid either by Cash, Check, or Charge. In the footer of the list I'd like to show totals by payment method, updated automatically as invoices are added.

I could create three buckets in every record, populating the appropriate one with the invoice total, and create three summary fields, but I wondered if there weren't a slicker way.



Share this post

Link to post
Share on other sites

It can be done like the attached template does it, although the entire approach suffer from metaphorical vanity. This means that allthough a summary field can behave when being shown in either the header or the footer, will the solution as such not scale particular well, since when ever a tiny detail is altered in the record a freshing of the summary field is re-calculated. Such a manipulation might be ...say clicking on the rolodex to go to the next record ...and the larger the found set proves to be the slower will the respose be from the solution.

I call this metaphorical vanity, because developers pretend that Filemaker is a spreadsheet, and forces thru a spreadsheetish metaphor there isn't catered for. Summaries in database applications is a scripted procedure, made on demand and certainly not something to render to every whim of the users interaction ...so eventhough it can be done is it in my humble opinion a misunderstanding of what databases are about!

So before you with frown adapt my attached solution, give the scripted approach a thought ...best of all realize how much better the linked approach from Kevin Franks page is by watching the CPU and/or network activity when dealing with 40000 and beyond records!




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.

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

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