I have a "common" table with about 60 fields which are common to one or more of 5 different tables. Initially a record in the common table is created by filling in a form. The "common" table is then APPENDed to each of the 5 tables thereby creating a new record in each and filling in the fields common to each respective table. This works fine (manually) although I still have to use a WHERE condition to ensure that I am only APPENDing new records.
The problem arises when I edit/modify one of the already APPENDed records in the "common" table (eg. change an address or a telephone number) and then try to reflect the change/changes in the same corresponding records in the respective tables previously APPENDed to. These other 5 tables contain fields which are NOT common and therefore may be edited individually through their own forms. I don't want to lose these edits.
I have been trying to accomplish this using an UPDATE query which seems to me to be the logical approach but I'm coming undone in the practical implementation or development of the required SQL. From there I want to create a VBA procedure (which presents its own challenges
)
I hope the above is understandable and any assistance will be greatly appreciated. Thanx.
The problem arises when I edit/modify one of the already APPENDed records in the "common" table (eg. change an address or a telephone number) and then try to reflect the change/changes in the same corresponding records in the respective tables previously APPENDed to. These other 5 tables contain fields which are NOT common and therefore may be edited individually through their own forms. I don't want to lose these edits.
I have been trying to accomplish this using an UPDATE query which seems to me to be the logical approach but I'm coming undone in the practical implementation or development of the required SQL. From there I want to create a VBA procedure (which presents its own challenges
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I hope the above is understandable and any assistance will be greatly appreciated. Thanx.