If you do it on ms access by downloading or linking the tables. It will not work.
But, if you create a pass-through query it will work:
SELECT
BKAPCHKH.BKAP_CHK_INVNUM,
MKICLASS.MKECLASS_DESC
FROM BKAPCHKH INNER JOIN MKICLASS ON BKAPCHKH.BKAP_CHK_INVNUM = MKICLASS.MKECLASS_NUM
Once you have your pass-through query with the proper "WHERE " (if you need one) then you can download the data for further analysis
Let me know how it goes.
Kelloggs