Update data from a database to another
Posted on 2004-03-23
I want a command button to do the following :
I have several tables with the same structure.
One is the "mother" one with the full database in one table called "MASTER"
The other is the "son" one with just a few records, so that user can work on its specific module - records are from table called "MASTER"
After updating information, user is resending me its "son" database
I want the button to update the records in my mother database from a command button from the "son" database, knowing that just the field "comments" from table "MASTER" is updated.
I cannot work it out.
Thanks for the help