Re: Pulling BOM data from BPCS into MS Word Document

["Bill" <brobins3d@xxxxxxxxx>]

Mike,

You have the capability to insert BPCS data into any ODBC compliant program
(which Word and Access are), if you have an ODBC driver for the 400 installed on
the PC.  There is one included with Client Access and it is free.  The mechanism
for accomplishing this data extraction is MS Query which is not installed as
part of the default Office installation, you would have to run Setup again to
have it installed if you didn't specify it the first time.

For your usage, you would want to create what is known as a parameterized query.
The query would then ask for the shop order number to pull the current FMA
records down and merge them into the document.

Bill


> Business Problem: Detailed process instructions exist in MS Word for
> products and this is dispatched to the plant for instructions. We want the
> current BOM (MBM or FMA) from BPCS to be pulled into this document to use
> as a shop packet. It seems that Mail Merge may be able to accomplish this.
> Anyone have experience with this or doing something similar with MS Word or
> MS Access where a user would enter an item number and shop order number and
> it would retrieve  the records from BPCS?



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com