Ellen,

Look in help, but here's a quick example:

Parent table:
id
name

Child table:
id
date
event

To show all the events, in order by name and date:

SELECT name, date, event FROM parent, child INTO CURSOR myCursor ORDER BY name, date

Use myCursor in the report writer. HTH. J

>Thanks for the reply. I guess I don't know how to use SQL Select.