thank you ,

kindly pe patient

how i can make relatins between two tables or more,to make inner join
i useto write mycode like....

select 1
use employee
locate for employee.no=thisform.text1.value
if found()

...do somthing

select 2
use salary
locate for salary.no=thisform.text1.value
if found()....and so on