I am afraid i am Sbasically Confused  ???

I have a form called basic info it has a subform called Invoice data. On the Invoice data subform it has a table subform to a form called Line item master.

When a search is performed the client data is displayed on the main form, invoice data is displayed in the subform and invoice detail is displayed on the table subform.

The InvTotal field on the Invoice data form is using on form entry and on element entry programming of

var vcnt as int
var vloop as int
var vmytotal as double
 
vmytotal = 0
vcnt = @FormResultSetTotal("Line item master")
vloop = 1
while vloop <= vcnt
{
  vmytotal = vmytotal + @tomoney(@FormFieldValue("line item master", "ItemExtAmt", vloop))
  vloop = vloop + 1
}
invtotal = vmytotal

To total all line items associated with that invoice and returning the total amount of that particular invoice.

The basic info form has a field called Invoicetotalall that uses on record entry logic of

var vAcnt as int
var vAloop as int
var vAmytotal as double
 
vAmytotal = 0
vAcnt = @FormResultSetTotal("inv data")
vAloop = 1
while vAloop <= vAcnt
{
  vAmytotal = vAmytotal + @tomoney(@FormFieldValue("inv data", "INVTOTAL", valoop))
  valoop = valoop + 1
}
InVoiceTotalAll = vAmytotal

To total all invoices for this client and returns the total amount the client has outstanding to the field InVoiceTotal.

My problems are first when my search finds the record it flashes the amount of times equal to the amount of line items. The math comes out correctly and all the data displays correctly but it looks real hokey.

The second problem is I have command buttons on the basic info form and on the invoice data form that has logic of

var vtable as int

if invRep <>  "mcsd"


{

     Vtable=@selectTreeitem ("Search Update Menu!Other Commands!Table View (Shift-F6)")
}

that pops up the data in table view format. Since I added the @FormResultSetTotal stuff I cannot use the table view buttons until I press save record. I figure the @FormResultSetTotal logic is updating the record each time its accessed so I need to save the record. Do I add the @save command to my table view logic or do I add Saving logic to the @FormResultSetTotal stuff?

Is my approach to what I would like to accomplish correct or are there better ways?

All help greatly appreciated.

Thanks

Quote:

How about providing a Forum Topic named Known Problems, and provide details about workarounds/status?  Read Only, maintained at your end.  Create some type of status ranking and update status as known.

Thanks Bharat_Naik for pointing that out.

Here is a link to the Known Issues page: http://www.lantica.com/Support/sesame_workarounds.html.

Looks good to see that it is current and that Sesame 1.01 already has fixes in it.