If the Import method is Add and Replace, the system uses the key to see if a record already exists. If yes, it will choose to Replace that record, if no, it will Add a new record.
To prepare this demo, remove some records from the Products table, and make some changes to the records, preferable also to the Category field.
In the Import an Validate form the Select Source Table tab gets focus.
Note that the table 'Products - original data' is used as a backup for the demo. Whenever you are done, you can use cut and paste on the whole table to get back the original data for Products and Suppliers.
After selecting the source table, the Select Destination Table tab gets focus.
We now want to select the Destination Table, in our case table Products. The reason there is a button instaed of a selection combo box is that it is possible to distribute the Source records data over multiple destination records.
The [Select Destination Table] dialog appears
In the transfer pane, an matching is done of Source and Destination fields. Not so surprising, all fields have been matched.
If you did your initial preparation ok, you should be able to find a record with changed values using the navigation buttons . An example is the below:
You can see two fields changed: CategoryID and Unitprice. As most people don't know what the category codes stand for, we will use a lookup technique.
The Old Value now displays the text corresponding to the ID. This went ok because the table's first two fields happened to contain the values we need: ID and Categoryname. If the table had been set up differently we would have made a query. New Value still has an ID. If we want to know what it stands for, click on the New Value popup button. You will see the current value selected.
If no changes have been detected, the [ Process Record] changes to [ No Changes - Next]
If you did your initial preparation ok, you should be able to find a new record.