reference table twice in same report different key

[almaragni]

I thought i had this easy - but i guess it is not so.

i have a single table (master) that needs to be referenced more than once by (plan) table. plan table has parent and child on each row. Master has information for each parent or child - as they are both considered items in the master.

plan table

parent - child1
parent - child2
parent - child3


i can link and reference desctiption for the parent from the master table in the report.

however, whenever I alias the master table in order to reference the child1/2/3 description in the report - i get errors.

parent link to master is right outer.
child1 link to master is ??? nothing sems to work
crystal8

any help appreciated.

thanks

 

[lbass]

I think all links should be left outer.

-LB

 

[lbass]

Also, if each child is a separate field (not a separate instance of the same field) in the plan table, then you would need to add the master table for each field.

-LB

 

[almaragni]

Thanks. I tried that - no luck
But when I switched the following it did work

(1) change driver to ODBC from SQL
(2) used Master to Plan for parent link
(3) used Plan to Master alias for child link

Master (parent) --- > PLAN ----> MASTER_1 (child)

that seemed to work.

thank you for your help