Dear Experts,

I have a Grid. The Record Source Is a Cursor Created on Form Load using Sql Pass Through (Cursor Name is: TestCursor).

In One Of the Grid Columns I have as ControlSource the following code:
lookup(xxx_view.chrname,TestCursor.chrid,xxx_view.chrid)

The Rest of the Grid Columns point to fields taken from TestCursor Cursor.

My question is the following:

Does the lookup function retrieves the lookup result(in my case xxx_view.chrname) for all items on the cursor TestCursor, or just for the ones shown on the Grid? (Meaning that when I scroll down the grid to see records not visible does it process the xxx_view.chrname lookup during scrolling or the values are taken from the begining)

Is it better to get xxx_view.chrname by joining the two tables during Sql Pass Through Operation or to use the lookup function?

Thanks in advance,

Spyros Christodoulou