Hi, I am trying to make a report in order to compare 5 list fields in Crystal Reports XI

All 5 lists have thier information held in one table (lets say DEFAULTDATA)

I can list the and create a formula field to show the actual category name and level for each one...

"
If {DEFAULTDATA.FIELDID} = 111106011187.00 then "Problem Category 1"
...
else if {DEFAULTDATA.FIELDID} = 111106011182.00 then "Incident Res Category 2"
...
else if {DEFAULTDATA.FIELDID} = 111106011203.00 then "Knowledge Category 5"
"

However these lists will be added too (and I need to check all five have been updated, spelt correctly and all match each other exactly.)

I am trying to show each items parent category name on the form however to do this manually as in the example above for category names is to long winded, prone to errors and very labour intensive.

I require the categories parent showing on its line. What will be the syntax for this?

Table [Defaultdata}
 FieldID                   The ID of the List name and category/sub category it is
 ActualValue            The number assigned to that record in the table.
 CosmeticValue       The actual text of that category
 ParentActualValue The ActualValue of this records Parent.

I want...
Match this FieldID and take ParentValue and display that ActualValues CosmeticValue from the matching FIELDID

but in correct syntax, if that makes sense?

ie

Name   FIELDID   ACTUALVALUE PARENTACTUALVALUE COSMETICVALUE  Parent
Problem Res Category 1 1111106011193.00 1  -1   IT Service Request 
Problem Res Category 2 1111106011194.00 5  1   Exchange Task  IT Service Request

Thanks
in advance and apologies but Im self taught and this is proving beyond my reach!

Col