I have a need to generate a simple report using DataReport and DataEnvironment. The Data base has three tables and I have been successful in relating two of the tables but not the third. Here is my Table Structure

tblClient
.... ClientID
.... ClientName
.... Other Fields
.
tblProject
.... ProjectID
.... ProjectName
.... Other fields
.
tblTasks
... TaskID
... ClientID
... ProjectID
... TextData
... Other Fields
'
The ID fields of each of the tables are UniqeIDs
'
I setup DE using the Client table as the master command then setup the Task table as a Child to it, relating ClientID to ClientID in both tables.
I can then drag and drop ClientName from the tblClient to the Group header and various fields from the Tasks Table to the detail section including the ProjectID.
'
' I run the report and the ClientName is properly displayed with associated task records below but the ProjectID is DISPLAYED AS A NUMBER.
'
I need to be able to relate the tblProjects ProjectName in such as way that the number is replaced by the ProjectName.

I have tried as many variations of parent to child relationships as I could think of but have not been able to do this.
'
I know I need to define the Project Table to the DataEnvironment t but have been unsuccessful in doing this in a way that it is recognized and the Project Name can be dragged to a Group Header.
'
Bear i mind this is a real new area for me and am not real versed in DataBase let alone DataReports etc.

Can anyone help me in relating both ClientID and ProjectID to the task table entries?
I would like to break on Client then Project within Client.
I realize this will take two Group headers but can not figure out how to achieve this.

PS. I am not adverse to changing the DataBase structure.

Thanks in advance,

John G Duffy