If I have two tables with similar fields is there a way I can update one table from another if records do not exist.
EG
Table1 has 3 fields plu, descr and quantity
This table is the main table and is used frequently.
I have a similar table (table2) which is only opened from time to time. Table2 is a copy of table1. If table1 has had extra data added since Table1 was last opened is there an easy way I can add the extra data to table2.
Can I check the contents of one table against another and update the table should it need updating?? Hope I make myself clear
EG
Table1 has 3 fields plu, descr and quantity
This table is the main table and is used frequently.
I have a similar table (table2) which is only opened from time to time. Table2 is a copy of table1. If table1 has had extra data added since Table1 was last opened is there an easy way I can add the extra data to table2.
Can I check the contents of one table against another and update the table should it need updating?? Hope I make myself clear