I have four tables which are as follows:

1. Simain ( Master File )
i. Sino C(8)
ii. Invdate D(8)
iii. pcode C(10)
iv. Salesman C(19) etc etc.

2. Sisub ( Transacation File )
i. Sino C(8)
ii. icode C(10)
iii. qntymaj N(13,2)
iv. qntymin N(13,2)
v. ratemaj N(13,2)
vi. ratemin N(13,2)

3. Pcode ( Customer File ) ( Relation with simain.dbf )
i. pcode C(10)
ii. pname C(52)

4. Icode ( Item Master File ) ( Relation with sisub.dbf )
i. icode C(10)
ii. full_desc C(52)

I want a cursor like in which it includes all the above fields. Before that a user has to input the following:

1. "from date" (variable mdt1) and "Upto" (Variable mdt2)
2. Salesman Name (Variable msalesman)
3. PartyCode (variable mpcode)

Please guide me to solve this query.

Thanks - Saif