Can you not do an SQL select to get all your data from the 4 tables into one cusor, then use this as the source of the report. It's not usual to have more than 1 table in a report. Don't have the table uin the report's DE and, in your field properties, omit the table/cursor name, e.g. MyCursor.CustName -> CustName.
Terry
>I generate a report which contains four tables, which I relate to each other. When I click on preview nothing displays and it comes into modify section again.
>
>The four tables are as follows:
>1. Somain ( Master ) index field is sono
>2. sosub ( transaction )
>3. pcode ( Customer Information )
>4. icode ( Product Information )
>
>Please suggest what is wrong with this.
>
>Thanks
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.