Master/Detail Report

Hi everyone,

I've 2 tables: 
Customer Table(Master Table) & Video Table(Detail Table).

The Video Table is linked to Customer Table through the 'CustNo' 
field, common to both tables:

Customer Table
CustNo   Name     DateBorrowed(yyyymmdd)
001      Susana   20030511
002      Louis    20030624

Video Table
CustNo   TransRef   VideoTitle
001      25841      Lord of the Ring
001      58742      Star Wars
002      65598      The Fugitive 
002      85454      Batman

At present, I've managed to do up a Master/Detail Report using 
1 TADOConnection, 2 TDataSource and 2 TTables, by setting Mastersource
of Video Table as DsCustomer & MasterFields as CustNo.
 
My Question is as follows:     
I want to be selective in choosing a range of date borrowed to view 
the report.

For example, in my TForm2, I want to have 2 DateTimePicker, label as:
Start Date & End Date, and 1 Preview Button.
When I click Start Date(eg, 20030501) & End Date(eg, 20030530), and 
click the Preview Button, I'm only able to see 1 record in the 
report, that is:
 
 CustNo  Name      TransRef     VideoTitle
  001    Susana    25841        Lord of the Ring
                   58742        Star Wars


Kindly advise me on how to implement the above.
Must I use a TADOQuery to link to the Customer DataSource(DsCustomer)?
I'm struck here. 

Thanks





















------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/uetFAA/i7folB/TM
---------------------------------------------------------------------~->

=============================================
QReport Artist 5 - http://www.mensand.com/
The new version is available for Delphi 5.0 ,
Delphi 4.0 and Delphi 3, BC++Builder 3.0. and BC++Builder 4.0 
============================================= 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/