For example, in the overview session, there is rows and columns. When i trying to add a data on the rows using display command is workable. But if there is more than 1 data, it will overwrite the first row. It suppose to go to the next rows to insert the data instead of overwrite it. What is the command to use, so that it can go to the next row to display the data?

You can use display.occ() or display.fld(). See manual for more info.

I try but still cannot, below is the code that i use:

select tfacp200.*
from tfacp200
where tfacp200.year = year
AND tfacp200.prod INRANGE {:period.f} AND {:period.t}
AND tfacp200.ifbp INRANGE {:ifbp.f} AND {:ifbp.t}

selectdo

long i
for i = 1 to 5

tfxxx200.isup = tfacp200.isup

display.fld(i,"tfxxx200.isup")

endfor

i = i + 1

endselect


RESULT: It will display the first record until 5 rows, then continue with the second record which will overwrite the previous 5 rows with the second record and continue again with the next record.

First Display:
A
A
A
A
A

Second record will overwrite the first display:
B
B
B
B
B

The correct result that i want is something like this:
A
B
C
D
E

One step back: Do you want create new records based upon tfacp200? Or do you want to update records from tfxxx200 with the tfacp200.isup field? In case of the latter must it be saved or is is it just temporarily to be shown?
Furthermore when should this happen? Is it a user action via a specific command or must this be done always?

Hi there,

All the information is for display only, no need to be save or update, the tfacp200 is the standard table which contain all the information that i need. Then the tfxxx200 is the table that i created to temporarily use for displaying the data of the tfacp200. I'm not sure that this is the correct method to do so or not. The important thing is after all the record that display out based on the condition that i set, then user can select those that needed by using checkbox that i created to print out the data.

For example, maybe the data that display out is:
A
B
C
D
E

And user may only want to print out A, C and D, so it will tick at the check box that i created. Then when it click at the print icon, the A,C,D will be print out.

But the problem now is, the data could not be display out properly, it keeps on overwriting.

Select the data to display in the before.display subsection of the field section of your display field depending on the values of the current record.

If i'm using display.fld() command to display all the record in the overview session (list window), then what is the command to retrieve/read the particular display data for every rows ?

See the answer in the separate thread you started. :)