Hi All,

I generate a report based on the following tables:

1. Somain.dbf ( Master File contains sono c(8), pcode c(8), date d, ...........)
2. Sosub.dbf ( Transaction file : sono c(8), icode c(8), qntymaj N(13,2), qntymin N(13,2), ratemaj N(13,20), ratemin N(13,20))
3. Pcode.dbf ( Customer File : pcode c(8), full_name c(63), address c(72) .....)
4. Icode.dbf ( Product Master File: icode c(8), full_desc c(72), ........)

I set the relation like: (Please note that I set the following relations in data environment).

sele 4
use icode orde icode alia item
sele 3
use pcode orde pcode alia party
sele 2
use sosub orde sono alia sosub
set rela to icode into item
sele 1
use somain orde sono alia somain
set rela to sono into sosub
set rela to pcode into party addi

Initially the report runs very fine, but after using a couple of times, it shows only one record of the transaction file (sosub.dbf).

Why it is happening? Please guide..

Thanks/Regards -Saifuddin