Two identical tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have two tables "TABLE1" and "TABLE2"

I want to make"TABLE2" contain the exact same fields and info of "Table1"
in addition to some other fields like "Language","Customer type","Remarks"...
"Table1" is updated automatically as it's linked to the inbox of the
outlook.
What i want to do is to by pass the updates (adding the new records to
TABLE2) by clicking on a button or any thing else suitable
Please advise
 
For the first time, copy Table1 to Table2 (right click and choose SaveAs)

After that run an append query to append new records. What you need to do is
add a field, called "Updated2" or something similar to TABLE1 and set its
DefaultValue property to False. Now after the append query runs, add an
update query to the button code which says something like:

Update Table1 Set Updated2 True;

Your next Append query appends all the records where Updated2 is set to
False.
 
Thank you very much..
But the problem is that i cannot add fields to TABL1 as it's linked to the
inbox of Outlook.
 
Hi all,

I created the append query,and it was agood idea to have the info in table1
,copied to table2,but the problem is that when a new row is created in table
1(a new mail is received),table2 is not updated with the last changes

Can you help,i need that whenever a new record is added to table1,it's added
also to table2
Regards
 
Back
Top