>I took out the SET SKIP and all it printed was the first record in each of the child tables. I thought you needed a SET SKIP when there was a one to many relationship?

Make sure you have the proper indexes defined on the child tables. Also make sure that you don't have any tables in the data environment that are messing up what you are trying to establish.

Here's some sample code taken from my article on MSDN. It shows how to set up the tables for a situation where there is a parent and three child tables.

*-- Open the child tables
USE Members IN 0 ORDER CustomerFK
USE Vehicles IN 0 ORDER CustomerFK
USE Homes IN 0 ORDER CustomerFK

*-- Open the parent table
SELECT 0
USE customer ORDER CustomerPK

*-- Set the relations between the parent and children
SET RELATION TO CustomerPK INTO Members
SET RELATION TO CustomerPK INTO Vehicles ADDITIVE
SET RELATION TO CustomerPK INTO Homes ADDITIVE

*-- Run the report
REPORT FORM Insurance PREVIEW