Hello,

I am very new to Crystal Reports and I am trying to grapple with the basics. Say I have a simple table, that is:
ID_Number, Name, Child_ID_Number.

And what I need to do is 'Display the name of the person of ID_Number '10' and the name of their child.'

This would require two SQL queries - one dependant on the result of the other.

So my report will have two name fields. I could use the 'select record expert' to get the data associated with ID_Number '10' but that's only halfway there.

I need the second field to understand its relationship with the first. What is the right way to go about this?
Formula fields? The select expert?
Thank you for any help.