ACTRANS and IC Transactions

We are trying to create a Crystal report that will inlcude the IC (Inventory Control) details for transactions posted to ACTRANS.

It does not appear that there is any link (object ID, etc) from ACTRANS to ICTRANS so we have been trying to link to MMDIST. The trouble is the the indexes on MMDIST do not inlcude AC items and the other indexes have items that are not inlcuded in the ACTRANS table. If we do not use the indexes, the performance is terrible (as MMDIST is a huge table)

Any help or information would be greatly appreciated.

Thanks.