Q: My table has no primary key but unique index is present. Can I use this table in the comparison process?
A: Yes, use unique key selection feature described in this section.

This dialog allows you to select column(s) for search records. You can use it if your table has not Primary Key or if you want to search and compare records by another column(s).
If the Primary Key is absent and the key is not specified, the program will not be able to perform the comparison or synchronization.

Remember that Primary Keys or unique keys of both tables should contain the same number of fields.

Notes:

• The program does not save any key definition changes into database. It uses unique key in the comparison project only.
• The program shows the related toolbar button pressed if you have custom key definition:
  You can press if once again to change the key.

Warning: be attentive when you select set of fields that correspond to the unique key. A non-unique key can cause data contamination during synchronization.