Hi,
I would like to ask question regarding customized table in company database.
Lets say we have DB called SAMLTD.
For customer requirement, I need to add another table 'CUSTOM' in SAMLTD to store information.
Then I have to sync this information with SAMLTD existing table such as APADV.
Hence, this is how I planned to do the sync:
I create a macro to do the sync & print invoice/voucher using Crystal report.
To sync APADV from macro, I will do Insert/Update/Select using the ACCPACCOMAPI.
To sync my table CUSTOM, I will do Insert/Update/Select using ADODB, since my CUSTOM table dont have ROTOID.
My question is,
1. If SAGE 300 do an update, will my table 'CUSTOM' inside SAMLTD be affected?
2. If table 'CUSTOM' does affected, what is the recommended way to create & access customized table?
