in table, I can use seek:

select stock
mkey='900020'
seek mkey order stock_id

how can I do it with view?

the view file is v_stock

thanks for the help.

regards,

Jerry