General information
Category:
Reports & Report designer
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only