I have the following, simplified, report I am trying to create in VFP 5.

2 tables related by a common field. It is a 1-n relationship. Table 1 has a requisition nunber and table 2 has multiple 1 to n lines for each requisition number. The report writer only shows the first line in table 2 even if it as more lines. Table 1 is ordered by its primary key, code, which is not the common field and table 2 is sorted by common field and line number. How do I get the report to display

code1
reqno11 lineno11
lineno12
.
.
reqno12 lineno21
lineno22
.
.

code2
reqno21 lineno11
lineno12
.
.


What I get is lineno11 for all records in table 2