I am trying to get a calcuation to display in custom menu and I think I need to use the Get Summary function but I have never used it before.

I have a field called "commission due" and a field called "Total commission Due" which is a summary field. I have set up a script to find any outstanding commission due based on a field called "Commission invoice number" being empty. this works fine. I am currently working on some custom menus for my database and would like the to total commission oustanding amount to display next to the menu.

This is what I have in my head

menu name

"Commission Due " & GetSummary (Total commission due ; commission invoice number = "")

obviously this is not right , but I don't know where to go from here

any help would be appreciated

thanks

If you take a closer look at the help for custum menu's will you be able to read this:

Menu and menu item titles based on field contents or functions only update when menu sets change.

It means you can't expect unstored values to show up, but even if you have two sets identical with a variable part, will there still be a syncronization issue, because it get's the unstored value from the point of time where the flipping was done.

Take a look:

http://www.filemaker.com/help/FMPA_Customizing%20Files16.html

--sd

Thanks, I thought I was being too ambitious :)

There is actually more to it:

http://developer.apple.com/documentation/UserExperience/Conceptual/OSXHIGuidelines/XHIGHIDesign/chapter_5_section_2.html#//apple_ref/doc/uid/TP30000353-TPXREF103

...although you seems to be on windows... Would I like to see a screendump where this is commonly used under windows, where it isn't a course to confusion, and games which entry of "warpfactors" seems to break every interface guideline known to mankind doesn't count here - give me a dump of a business application where it makes sense!

I can perhaps guess where you might be aiming, you wish to show availability, to prevent plucking unavailable items. Here could it be good study to investigate this:

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

--sd