Crystal Reports - Link ICTRANS with APVENMAST

Sort:
You are not authorized to post a reply.
Author
Messages
Alicia
Basic Member
Posts: 14
Basic Member
    I have a Crystal Report which consists of ICTRANS fields.  I need to pull in the Vendor Number and Vendor Name associated with the ICTRANS Item Number.  The APVENMAST table contains the Vendor data that I need.  Is it possible to link ICTRANS with APVENMAST (or some other table) to get the Vendor Number and Name?  FYI, currently, the Crystal Report consists of the following tables:  ICITLUF, ICMXVAL, ICTRANS, ITEMLOC, ITEMMAST.
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      You're on the right track. Try adding ITEMSRC (connect to ITEMLOC) . Connect APVENMAST to ITEMSRC.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Alicia
      Basic Member
      Posts: 14
      Basic Member
        Ok, I will give it a try.  Thanks, Jon!
        Alicia
        Basic Member
        Posts: 14
        Basic Member
          Thanks again, Jon!  I was able to get the link to work as you suggested.
          You are not authorized to post a reply.