Creating Unique Primary and Foreign Keys After the Fact
If this has been discussed before please forgive me and point me to a more appropriate thread.
I just inherited a simple "one to many" 2-table database (but has over 700 records) so far. The PK was set as a text field called Catalog Number which was related to a FK (text) named the same thing in the other table.
The problem i discovered was that the PK in the catalog table wasn't set to be unique or auto-entered so as a result I have duplicate catalog numbers in the primary table with different data.
I know how to create a new pkID field that is auto-entered and then populate it.. but what about the other table. If I create the fkID field in the other table, what's the best practice to make sure i have the most accurate data on the other side?
Hope that makes sense and thanks in advance for the advice.