Showing all records of group if one record of group matches criterea

[posero]

I am using Crystal 6/7/or 8 and a relational btrieve database.&nbsp;&nbsp;<br><br>I want to be able to work with all records of a group if one record of that group meets a certain criterea.<br><br>e.g.: (all within one table:&nbsp;&nbsp;{Schedule.dat}) I would like to display all appointments of a patient if one of his appointments has a status of X on a certain day.&nbsp;&nbsp;(all within one table)<br><br>A previous response returned that I should link schedule to patient to schedule, and base my selection on the first schedule table.&nbsp;&nbsp;This will work, but for a very small database the response takes over 10 minutes.<br><br>I can use sub-reports for this as it takes only 30 seconds to generate the solution (main report selects only patients with status X, and these patients are returned to the sub-report, which prints all the records for the patient).&nbsp;&nbsp;However, this generates an error in Crystal (7 or 8, Win 95, Win NT, on variously configured systems):&nbsp;&nbsp;&quot;Btrieve [87], handle table full&quot;, after which Crystal refuses to access the same database again til Windows is re-booted.&nbsp;&nbsp;<br><br>I would desperately want to avoid this problem, so I need a way of solving the above problem without using sub-reports.<br><br>Thanks !<br><br><br>