AnsweredAssumed Answered

Record ID pk / fk fields -- can I create them after the fact?

Question asked by firth5 on Mar 24, 2010
Latest reply on Mar 25, 2010 by philmodjunk

Title

Record ID pk / fk fields -- can I create them after the fact?

Post

I'm working on a database that's been in use for a couple of years (I did not create it) and has over 10k records.  Many of the tables link to multiple fields in the central hub.  I think it would be better served if the central hub used an ID pk, and the other tables linked to this with an ID fk.

 

Can I add these pk / fk fields after the fact?

If so, what is the safest way to do so?

Outcomes