PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/22/2017 9:34 AM by  JimY
AP10.2 Contact Account Number
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
pglibra
Supply Chain Revenue Coordinator
Private
Basic Member
(25 points)
Basic Member
Posts:11


Send Message:

--
08/22/2017 8:34 AM
    Hello,
    I am trying to write an Access query to pull the vendor's account number that can be found in AP10.2, Contact, Account Number.
    What tables do I need and how do I link them in Access?

    Thank you
    Randy
    Systems Administrator
    Rochester Regional Health
    Advanced Member
    (85 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    08/22/2017 8:49 AM
    Everything appears to be in APVENLOC Table.
    pglibra
    Supply Chain Revenue Coordinator
    Private
    Basic Member
    (25 points)
    Basic Member
    Posts:11


    Send Message:

    --
    08/22/2017 8:52 AM
    Got it.
    Was making it more difficult than it was.
    Thanks
    JimY
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    08/22/2017 9:34 AM
    If you also want vendor address information you will want APVENADDR. Make sure you get the current address.
    You are not authorized to post a reply.