To make it possible to enter orders of clients at the site of the client itself, some coworkers have a mini-laptop with a MS Access databaseprogram. This database consists of the tables "tblClients" and "tblArticles" as well as a table "tblOrders" and a table "tblOrderdetails". The first two tables are copies of the tables with the same name and the same records as they are present in the database at the main-office.
Coworkers,visiting there clients, enter the orders of the clients in there database and at the end of the day, these orders are converted to a comma separated txt file and in this form as attachement sent to the office via Email.
To keep track of the changes made to the tables "tblClients" and "tblArticles" in the database at the main-office, each time a record is changed or added , these changes has to be sent to the database on the laptop of the coworker. Therefore by mean of a query, the records that are new or have been changed are put together in a tempory table, converted to a comma separated txt file and sent as attachemant via an email to the coworker. Once this attachement is imported at the site of the coworker it is converted back to a tempory table in the database .
Because this tempory table can hold changed records as well as new ones, the necessary updating not only consists of appending new records to the table (e.g. tblClients") but also replacing existing records by the equivalent changed ones.
My question now is the following one:
Can these two things be done at the same time?
Can this be done , especially replacing records, while a relation exists between the data in the table "tblClients" and the table "tblOrders" in the database on the laptop of the coworker,and last but not least does there exist any better and simpler way to obtain the same goal?
Coworkers,visiting there clients, enter the orders of the clients in there database and at the end of the day, these orders are converted to a comma separated txt file and in this form as attachement sent to the office via Email.
To keep track of the changes made to the tables "tblClients" and "tblArticles" in the database at the main-office, each time a record is changed or added , these changes has to be sent to the database on the laptop of the coworker. Therefore by mean of a query, the records that are new or have been changed are put together in a tempory table, converted to a comma separated txt file and sent as attachemant via an email to the coworker. Once this attachement is imported at the site of the coworker it is converted back to a tempory table in the database .
Because this tempory table can hold changed records as well as new ones, the necessary updating not only consists of appending new records to the table (e.g. tblClients") but also replacing existing records by the equivalent changed ones.
My question now is the following one:
Can these two things be done at the same time?
Can this be done , especially replacing records, while a relation exists between the data in the table "tblClients" and the table "tblOrders" in the database on the laptop of the coworker,and last but not least does there exist any better and simpler way to obtain the same goal?
