For something like an ECN or external document transmittal, does anyone have a good example of a document that will search the database for the files linked to that document and then populate the table on that document with the appropriate information (drawing/file number, description. current revision, new revision approval dated etc)?
Barry,
Yes, it is possible to make your request workable.
A VB macro can be written within MS Word file to find out the files linked to ECO (in EPDM) and as well link the variable values linked to the each of the files. A little experience with EPDM API and as well as VBA scripting in Office applications, you should be able to accomplish what you are looking for. We accomplished this request to one of our group companies. The overall scenario is little different but the working approach\architecture remains the same.
Hope this information helps.