AnsweredAssumed Answered

Creating Unique Primary and Foreign Keys After the Fact

Question asked by themactech. on Aug 26, 2014
Latest reply on Aug 26, 2014 by philmodjunk

Title

Creating Unique Primary and Foreign Keys After the Fact

Post

     Hi All

     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.

     CL

Outcomes