>What would you suggest to make this happen? Once again, changing the index for the dbf makes the report NOT work.
>
Jim,
First make sure SET EXACT is OFF, none of this will work with exact set ON. Change the data type of FP_PO top character, that is unless you need to calculate the average PO number very often.
Then build your index as the concatenation of PO number and Line number, the set exact will cause the match to occur on the related field in the po master table. Also make sure the two PO fields are the same length and the same data type.