I'll see if I can ask this in as few word as possible.

If I have three row sets on a page, can data in one change the selection in 
another?

Three tables/rowsets
        invoices
        line items
        transactions

The transaction table stores different kinds of transaction. After a qry_one on 
the invoice and building a row set, another row set is built for the customer 
payments related to the invoice (from related transactions).

Line items belong to invoice, but different kinds of transactions belong to the 
line item, payments to vendors, which are summed up in a callback and stuck 
into the line items row set.

The view displays invoices, line items and payments in separate div's.

If I display them in the order

        invoice
        lineitem
        payments

The payments row set data contains the wrong data. If I have three payments, 
all three will display the same transaction that is not related in any way to 
the invoice or line item (not first record, but close).

If I display (iterate through) payments before line items, the data is right. 
Again, line items has a callback that queries transactions.

Can it be that going through the row set line items changes the selection of 
payments?

Steve

PS, I did not design this convoluted mess!





_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Reply via email to