Updating One Table from another Table

[split_atom18]

I have a database that is made by a third party.
I have built a second database basically as a bunch of addons for the for third party.
They have a customer table in their db. (with less fields then i need)
I have a customer table in my db. (with more fields then theirs)
I intend to have a query that runs on open of my database, what it will do is:
Match the two tables up against each other. Update any field that has been updated in the third party db to my db.
It will add any customers that are in the third party database, (that aren't in my db)in to my database.

I hope all that makes sense. I am really not sure where to start. Do I use an update query or append? I want the data to be stored in both places. (only because I have no choice)

Let me know if you need more information.

Thanks

Dan

[ConneXionLost]

Hi Dan,

You may want to consider using more than one query and take it a step at a time.

First query to append new records to your db
Second query to update your current records

There should be no problem in running both queries from the On Open event.

Cheers,

[split_atom18]

ConneXionLost,

Thanks for the suggestions. That is what I was working on doing this morning. I should have posted what I was trying. The append query for somereason was adding new every item each time. so my table was doubling in size. I figured out that problem. Your solution works though thanks much for you help.