Automatically update some but not all fields to another database table

[jim-jones]

Hi I have a table in one database (table1) which when new records are added or amened I want it these changes to be automatically updated to another table in a different database (table 2). I know this would be done by linking the tables but the problem is I don't want the structure of the tables to be exactly the same. I want only 3 fields from the original table (table1) These 3 fields would be in table 2 along with other fields.

So basically is it possible to amend 3 rows from table 1 and have these amendments in table 2 without having to retype the data and mess around with and update or make table query every time, basically have it done automatically with VBA or something. I can't figure out the best way to do it.

regards

 

[wilpeter]

Have you considered an update query that selects those fields from Table1 and updates Table2 that is linked?

 

[wilpeter]

In case you haven't worked with this approach, see the two tables attached. First, you would have to link them (as you mentioned), then look at the two records in the automatically displayed form. Click the Update command box and observe the change in the values of the subform.

 

[jim-jones]

Thanks for this. I have checked the query and got it working. I had tried using a similar update query before but without success. I will investigate how it is done here and use it on my tables.

Regards

 

[namliam]

You shouldnt duplicate data between databases this will inevitably cause problems.

Instead just fetch the data from the original database when needed.