I have 5 similar databases in 5 separate folders. Tablenames are identical in each database.
All databases contain a table named Constransactions.dbf
In one of these databases (NIMSInternational) users enter records that are uniquely identified by a field that designates which database they are to be posted to (so I know which of the other 4 databases is the target for the record).
After a few records (say 100 or so) have been entered in the NIMSInternatioinal database, I want to 'Post' each record to the correct target database. This would be easy if all Constransaction.dbf tables were in the same folder in the NIMSInternational database... but the tables have the same name.
I could leave the Constransaction.dbf tables in their individual folders and add all of these tables to the NIMSInternational database... then create Append Opperations... but since these tables are in different folders/databases this would make the app difficult to transport to other computers / drive letters C: L: K: etc.
I could export the records as .csv or .txt from the NIMSInternational database and then individually import them back to each database... but I would rather have this happen automatically from the NIMSInternational database without user actions in the other individual databases.
Is there a way to 'Post' these records from the NIMSInternational database to the external databases so that no user action is required in the individual (target) databases?
All databases contain a table named Constransactions.dbf
In one of these databases (NIMSInternational) users enter records that are uniquely identified by a field that designates which database they are to be posted to (so I know which of the other 4 databases is the target for the record).
After a few records (say 100 or so) have been entered in the NIMSInternatioinal database, I want to 'Post' each record to the correct target database. This would be easy if all Constransaction.dbf tables were in the same folder in the NIMSInternational database... but the tables have the same name.
I could leave the Constransaction.dbf tables in their individual folders and add all of these tables to the NIMSInternational database... then create Append Opperations... but since these tables are in different folders/databases this would make the app difficult to transport to other computers / drive letters C: L: K: etc.
I could export the records as .csv or .txt from the NIMSInternational database and then individually import them back to each database... but I would rather have this happen automatically from the NIMSInternational database without user actions in the other individual databases.
Is there a way to 'Post' these records from the NIMSInternational database to the external databases so that no user action is required in the individual (target) databases?
Comment