>I am Alberto I programme VFP in my agency and I have this problem, I have to elaborate a report with the following files:
>
>1. Firms
>2. People(file related to firms fields id_code, a few people for every firm )
>3. Offers(file related to firms fields id_code, many offers for each firm )
>
>Until I try to relate 2 tables can manage it but I can only see the 1st on the 3rd file.
>
>Alberto
Alberto, it can be done, but it's a little complicated. I'm assuming you want the report to show all the people for Firm1, then all the offers for Firm1, then go on to Firm2......
1. Make a SQL cursor that has the firm information and the people information.
2. Make a SQL cursor that has the firm information and the offers information.
Make sure the field names for the people fields are the same as the field names for the Offers fields.
3. Make a final cursor that has the information from both the above cursors, plus a field that you fill with "A" for people, "B" for offers. You can either append data from the other two cursors or do a join.
Then print your report ordering by firm and the "A/B" field. Your detail line will show first people then offers.
This is a pretty quick review, I hope it's clear.
Barbara