Ok, I've done a lengthy search on this in the UT and I must not be asking the right questions because I can't find anyting. I also know I've done this before but for some reason I'm having a brain fart.

I have a report that pulls data from a temporary cursot that gets built on the fly with a sql statement. The cursor is called tempcur.

One of the fields in the detail band of my report has the following express oApp.GetBval(). GetBval is a method of my application object that that returns a numerical value. To do this, in the method I'm doing a seek in another table based on the value in tempcur.cust_id.

The problem is that record pointer in tempcur does not appear to be moving because I get the same value in that field for all of the records. What am I doing wrong here? Is there a better way to do this, maybe by setting up a relationship from the temporary cursor, into the other table? And if so, will that cause the pointer to move?

I know I'm going to feel dumb when I get the answer to this, because I remember facing this before and the solution was really simple.

Thanks in advance!!!

-Rick