Bill It is difficult to answer in a way since I dont see your picture But taken from my enviroment maybee you ca trie Print your _report where driverdates beteween . vday1 and .vday2 and car_id in (select car_id from vehicles where car_id = .vyourselected car) That the best I can do witout understanding your issue better
Gunnar Ekblad -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Bill Niehaus Skickat: den 27 maj 2009 21:33 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Selection criteria based upon sub-reports Is there a way to select records that print based upon the table in the main report as well as the table in the sub report? I can get records from the main table by using a condition in a WHERE clause, but don't know how to select based upon columns in the sub report. Using V8. Thanks. Bill Niehaus

