Update query

[Topher]

Scenario:

1) I run a Make Table query that creates a table filled with records
that are the results of a complicated query against a set of
inter-related tables.

2) I then change something in the tables that will alter the output
that the query generates. In fact, the query will now generate fewer
records and many records will be different.

3) I want to run the query again in an UPDATE mode (I think) such that
the changed records will overwrite the old records in the output table,
but records in the output table that are no longer generated my the
query will be left alone.

My reason is this: I have to keep an electronic device synchronized
with the results of the query, which means sending new (changed)
records to it. However, it also means sending "delete" instructions for
those records that are no longer generated by the query.

Any ideas on how to detect records that are no longer there?

Topher

 

[Guest]

Seems to me that you just keep running the Make Table query. It will drop the
old table and create a new table with only the most up to date records.

 

[Topher]

The problem is that I need to know the records that it dropped, because
I need to go delete them from the devices. It would be great if I could
get a list of all the records that existed in the previous table and
then did not get generated in the new one.