two unequal link values to same SQL Server db table

[pvirsf]

I am building a CR 9 report where I have two values of a link, at the same time as the report runs, and I need to link to a given SQL Server db table to do two look-ups. Can a second alias for the look-up table be accessed by the second link value? The SQL query generated by CR seems to accept this, but I always get a null result of the second look-up. Any thoughts on this would be appreciated.

 

[synapsevampire]

You can add in a table a second time and alias it, but you might want to do a Left Outer at least during testing.

Ratgher than trying to describe data with text, try posting example data and the fields and data types which require linking, and then the expected output based on this.

-k

 

[pvirsf]

Thks for your response.
I have tables T1,T2,T3,T4
T1 is Left Outer Joined(LOJ) to T2 on field F1
T1 is LOJ'd to T3 on F2
T2 is LOJ'd to T4 on F3
T3 is LOJ'd to T4_1 om F4 (this is employing the alias for T4)

For a record in T1, I want to use the value in F3 and the link to T4, to look up the related value of F5.

Concurrently, for that record in T1, I want to use the value in F4 and the link to T4_1 to look up a different related value for F5.

So now I could print T4.F5 and T4_1.F5 at the same time.
Hope this helped explain what I need to do. Thks in advance.