Specifying the Columns
You can specify which columns in your tables are to be compared by clicking on the Columns tab. This shows you the columns in your tables / queries.
- on the left grid, select the Compare checkboxes to include or exclude a column from the compare.
- on the right grid, you can move entries up or down. You do this to indicate which column in second table matches the column in the first table.
- the Insert Entry and Delete Entry buttons are useful if you need to add a blank row to the grid. You will need to do this if your first table has a column which doesn't correspond to any column in the second table. In this case you match this column to a blank entry.
- columns which will not be compared are "greyed-out".
- the Key checkbox can be used to specify which columns in the table comprise the unique key