that's the code
if :block6.list46 = 1 then
select book_no,book_name,b_type,location,authour,borrow,borrow_no,year
into :block6.TEXT_ITEM65,:block6.TEXT_ITEM66,:block6.TEXT_ITEM67,:block6.TEXT_ITEM68,
:block6.TEXT_ITEM69,:block6.TEXT_ITEM70,:block6.TEXT_ITEM71,:block6.TEXT_ITEM75
from books,book_type
where book_no=:block6.TEXT_ITEM45 and book_type=bt_no;







else if :block6.list46 = 2 then
select book_no,book_name,b_type,location,authour,borrow,borrow_no,year
into :block6.TEXT_ITEM65,:block6.TEXT_ITEM66,:block6.TEXT_ITEM67,:block6.TEXT_ITEM68,
:block6.TEXT_ITEM69,:block6.TEXT_ITEM70,:block6.TEXT_ITEM71,:block6.TEXT_ITEM75
from books,book_type
where book_name like :block6.TEXT_ITEM45 and book_type=bt_no;

if the search result is more than one row the result not appear
howa can i display more than one row in that result row using 2 butons next and previous or any other solution

Thnx
M.T

you must to use tubler view to do what you wanet

ehab wagdi