I have 2 Tables in attached DB
Imported
And
AllDataSource
I want to create query append data from Table Imported to AllDataSource but if the the record is exist in AllDataSource Update the record in All Data Source Table
1- Append Data from Imported Table To AllDataSource
2- if record exists in AllDataSource then update based on Table Imported
3 - Shared field is ClientNo and Order No between 2 Tables
Imported
And
AllDataSource
I want to create query append data from Table Imported to AllDataSource but if the the record is exist in AllDataSource Update the record in All Data Source Table
1- Append Data from Imported Table To AllDataSource
2- if record exists in AllDataSource then update based on Table Imported
3 - Shared field is ClientNo and Order No between 2 Tables