Hello,
I have used the pick links all the time with no ill effects that I know of. It is easier than adding tables and creating the relationships.
On the ARForm report, I found an example of how to name the pick link to access it.
T1.CurrencyCode_CurrencyID
T1 points to table that has the pick link (InvcHead for this example)
CurrencyCode = the pick link tab selection from RDD
CurrencyID = Pick field on the Description fields tab from RDD.
Note the underscore that connects the pick link to the pick field.
If you have any other questions, please reply and I will answer to the best of my ability.
Thanks,
Shawn
_________________________ Addendum _____________________________
On how to tell which t1, t2, etc to use. Below id at excerpt form the ARForm .
FROM InvcHead" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN FSCallDt" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.InvoiceLine = T3.Calc_InvoiceLine AND T2.InvoiceNum = T3.Calc_InvoiceNum
LEFT OUTER JOIN FSCallMt" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.CallNum = T4.CallNum AND T3.Calc_fCallLine = T4.Calc_fCallLine AND T3.Calc_InvoiceLine = T4.Calc_InvoiceLine AND T3.Calc_InvoiceNum = T4.Calc_InvoiceNum
I put the T1, T2, etc in bold. Notice in each line that the T desgniations show, there is a table name listed.
I also put those table names in bold.
What the T1 does is give the SELECT statement a nickname for the table being referenced.
If you didn’t do that, then you would have to type out the table name before each field.
For the above example, you could have changed
T1.CurrencyCode_CurrencyID
to be
InvcHead.CurrencyCode_CurrencyID
and it would work the same.