hi!...any idea for this scenario?
i have 2 tables, Tables A and B...both contains customer information...table A has a field that is defined as a flowfield...the field's name is "Amount"...then in table B, i have a field (named "Total Amount") that is also a flowfield and that needs to get the sum of values in the "Amount" field from table A for the corresponding customer that the user inputs in table B....
any idea on this?...thanks in advance!
Comments
I think u need to make use of same sumindex field that you have used for Table A.
Sound simiar to Balance field in Vendor Table which is showing Vendor ledger entries in look up(on form) but actually making use of Detailed Vendor Ledger Entries.
Hope this Helps.
Regards,
Rajesh S