J
jdbit2byte
I am wondering if anyone has knowledge of importing Forefront data through
Forefront's info-link and an Access Query. I have found ads on a class
teaching people how to do this but no other documentation on the matter.
I want to pull from two modules in Forefront to a single table in Access.
The Module, Table, and Column info are:
Table: WO_HEADER_MC
Module: WO
Column: JOB_NUMBER, COMPANY_CODE
Table: CR_CUSTOMER_MASTER_MC
Module: AR
Column: COMPANY_CODE, NAME, ADDRESS_1, ADDRESS_2
By combining these I am hoping to make a single table showing all job
numbers with company names and addresses.
Forefront's info-link and an Access Query. I have found ads on a class
teaching people how to do this but no other documentation on the matter.
I want to pull from two modules in Forefront to a single table in Access.
The Module, Table, and Column info are:
Table: WO_HEADER_MC
Module: WO
Column: JOB_NUMBER, COMPANY_CODE
Table: CR_CUSTOMER_MASTER_MC
Module: AR
Column: COMPANY_CODE, NAME, ADDRESS_1, ADDRESS_2
By combining these I am hoping to make a single table showing all job
numbers with company names and addresses.