Home » Developer & Programmer » Forms » Sub Total (Forms 6i)
Sub Total [message #423714] Sun, 27 September 2009 03:29 Go to next message
mat_vargh@yahoo.com
Messages: 1
Registered: September 2009
Junior Member
Hi,

I have a form with 4 column...
Eg., Company, Brand, Item, qty.

I want to show the subtotal for each brand (for the qty field) in this form. Please advise.

Thanks in advance.
Re: Sub Total [message #423737 is a reply to message #423714] Sun, 27 September 2009 12:49 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do you "imagine" that form? It appears that number of items may differ, which means that you can not "dynamically" move that "subtotal" item throughout the form. Moreover, where would you put it if a certain brand contains more items than records on a page?

Though, perhaps you could create a single "subtotal" item (for a current brand - the one that has focus on it) and calculate its value in a PRE-RECORD trigger (for example).
Previous Topic: subclass information
Next Topic: Data compression
Goto Forum:
  


Current Time: Fri Sep 20 11:43:08 CDT 2024