This solution requires certain accumulative information from our legacy
system, my problem is... I want to automate this entirely. The legacy is a
Progress system on a AIX box. I can use SQL and DTS to take data from the
legacy system and manipulate it. Then use FileMaker's odbc for sql to
import the data.
To automate, I'm looking at creating interfaces between the two systems,
utilizing Visual Basic. From What I've read, I'm thinking you should be
able to do this. I know from Visual Basic you can access certain objects
and methods from FileMaker, limited though. Any assistance or knowledge of
this would be helpfull.