I have a recipe database that is broken up into 3 tables that are related with a common ID.  I have a recipe table, ingredient table and directions table.  The recipe table contains a single recipe rows.  One row for each recipe and a generated ID. 

 

The ingredient table contains multiple rows (one row for each ingredient in a given recipe) and a ID linking these ingredients to the recipe table.

 

The direction rows contain multiple rows (one row for each direction in a given recipe) and a ID linking these directions to the recipe table.

 

I want to use crystal reports to create a recipe book.  That is each page should contain the recipe, all ingredients for the given recipe ID and all directions for the given recipe ID. 

 

I've tried importing all tables or importing a stored procedure.  However, Crystal keeps repeating data or making a cartesean product.  I don't want to do subreports because they are not related with each other....