needs cleaning up

[#1]

Hi

I have a report that brings in historical Invoiced Sales (ZAPInvFinal), Static on hold and on pick orders (OnHoldOnPickFinal) and forecast sales (Forecast Final).

I cannot concatenate the ZAPInvFinal and OnHoldOnPickFinal as they are compatible but can I create a link table. I dont know how to do this.

At present the report works but I want to add the ForecastCustomerDiv into the OnHold OnPick sales but as it is a mess the file size goes from 4MB to 25MB

any help appreciated

David

[MichaelRobertshaw]

I don't see why you could not concatenate these two similar tables. Simply add another column to each load statement indicating which source the data comes from. That will enable you to still distinguish the data.

Otherwise, there is a useful explanation of Link Tables at http://www.quickqlearqool.nl/?p=910