One way you could accomplish this is to create a subform with all the line items (if you don't want it to be shown make it invisible - haven't tested this part yet).

you can then set up some programming to loop through each item in the list and get the information you want form it and display it to the user.

If you want more detailed examples I'll dig up the programming to loop through the line items.

Glad to help I like thinking outside of the box. Its not that i'm claustrophobic or anything but its just so much more interesting It just sort of works out that i'm working on something kind of similar currently.

As far as I can tell you can only perform looping on subforms. There is no way that i've seen to loop on a database when it is not a subform.

Justin

Here is an example that loops through a subform containing payments and totals all the payments. You can do anything you want with the data (post messages to a multi-line text box that is unbound, etc.)

If you have any questions let me know. All variables start with a v all other variable-type objects in the code are layout elements.

////////////////////////////////////////////////////////////////////////////////
// Loop through a subform and total all payments
////////////////////////////////////////////////////////////////////////////////

// Declare Variables
var vCnt as Int			// total number of records in subtable.
var vLoop As Int		// Counter to be used to increment from one record to the next in the subtable
var vMyTotalHere as Double	// total of payments made to us
var vMyTotalDIR as Double	// total of payments made to client
var vMyTotalCHere as Double	// commission on payments made to us
var vMyTotalCDIR as Double	// commision on payments made to client
var vPayDate as Date		// Date of Payment

///////////////////////////////////////////////////////////////////////////////
//  Calculate the totals of payments and recalculate the outstanding balance
///////////////////////////////////////////////////////////////////////////////

// initialize payments sum
vMyTotalHere = 0;
vMyTotalDIR  = 0;
vMyTotalCHere = 0;
vMyTotalCDIR  = 0;

// retrieve number of records
vCnt = @FormResultSetTotal("Payments Table");

// verify if there are any new payments
if vCnt <> PrevPayments: then
{	// if there are new payments update the payment counter (refreshed on form load)
	PrevPayments: = vCnt;

	// start at the first payment
	vLoop = 1;

	// loop through all payments
	while vLoop <= vCnt
	{

		// get the sum of the payments
		vMyTotalHere = vMyTotalHere+@ToMoney(@FormFieldValue("Payments Table","PmtHere", vLoop));
		vMyTotalDIR = vMyTotalDIR+@ToMoney(@FormFieldValue("Payments Table","PmtDIR", vLoop));
		vMyTotalCHere = vMyTotalCHere+@ToMoney(@FormFieldValue("Payments Table","ComHere", vLoop));
		vMyTotalCDIR = vMyTotalCDIR+@ToMoney(@FormFieldValue("Payments Table","ComDIR", vLoop));

		// get the date of each payment
		vPayDate = @ToDate(@FormFieldValue("Payments Table","PmtDate",vLoop));

		// move to next payment
		vLoop = vLoop + 1;
	}

	// Display totals in summary boxes.
	Payments Here:    = vMyTotalHere
	Payments DIR:     = vMyTotalDIR
	Total Payments:   = vMyTotalHere + vMyTotalDIR
	Commission Here:  = vMyTotalCHere
	Commission DIR:   = vMyTotalCDIR
	Total Commission: = vMyTotalCHere + vMyTotalCDIR
}
 

Quote:


Hammer,

If a user has the form in question open will it start cycling through it or will it leave it at the point they had it? I was under the impression that this is waht happens. Also what would happen if that form wasn't open?

Thanks,
Justin

Oops lol sorry Mark, I was thinking about the e-mail notification when i started the reply.

I was wondering if that is the case I have a theory I'd like to run by. Our database has accounts and payments, I would like to have the program cycle through all the current payments on the account, sum them up before it calculates the comission on the next payment would it be possible to do this using that code you suggested. The reason for this is we have some sliding scale comission rates and it won't calculate them correctly unless it knows what payments have been made first. I want this code to execute on add payment - i know i'll have more difficult later one when they are correcting a payment but one step at a time.

If it will let me loop on the active form I also have one other question. Does it automatically commit existing changes on the form before it starts flipping through them or does it record which changes there are and then restore the form "as is" or does it discard the change?

Justin

I was just thinking would it be possible to use something like @userselect - the same command to populate a popup window to maybe pull up certain pieces of information?

Justin