>Dear Experts
>
>list1 contains data as
>1
>5
>3
>7
>
>that is actually gate_no
>
>From Table1, I want to get records those gate_no is equal to list1.gate_no.
>
>How to enter gate_no reference from list1.
>

>Select gate_no from table1 where gate_no = thisform.list1.gate_no....... into cursor
>

>Please help

Tr y

select gate_no from table1 where gate_no = thisform.list1.List(thisform.list1.ListIndex,1) ... into cursor