When I import a qualified lookup table it duplicates records. Whats the right way to avoid it?
When you right click on the field of the main table that points to the qualified lookup table, choose “set qualified update”. Then three options of how to treat repeating values appear. Option “Append” will add new records. Option “Replace” will replace it. And option “Update” will update them. In all three cases an additional option appears where you can specify how to match existing records through available qualifiers.
