Administration, Core Financials, and Project Accounting

[trodman]

I have a question related to this issue.

I'm not sure how the tciAddressWrk_1 table gets populated.  I can see in the sppoPopPOPrintWrkTbls stored procedure where tciAddressWrk gets populated, but I don't see anything for tciAddressWrk_1.  Does anyone know how I can modify the way tciAddressWrk_1 gets populated?

[hsanguino]

Hi Tim

The tciAddressWrk_1 is actually another alias for tciAddressWrk alias (every table object added to a report is actually an alias).

Crystal Reports allows you to add multiple instances of same table, so you get the name of the table + _n  where "n" is the sequential number of instance.

Hugo

[trodman]

I see now.  They're all joining to tciAddressWrk, but each alias is joining based on a different AddrKey so you wind up with different address records in each aliased table.