I am new to DB reporting and am using Crystal 10. My current report is two pages and reqiures the info of
the main person in the report and then the information of other related people, ie parents and siblings. The problem is
that all this information is in the same table the "person" table. I have linking gone from the persons table to another table which then links back to person table to find the related person via the person_id (key to person table and secondary key in many other tables).
Forexample. I lookup john and drag his name from the field explorer to the report canvas. But I also need to the name of his sibling which also resides in the person table. I have all the tables linked but I need to know how to get all this information in one row. I hope this makes sense any help would be appreciated.