AnsweredAssumed Answered

Relatively new (and small) database - question about moving to FM 17, primary keys and related records

Question asked by halatkins on May 24, 2018
Latest reply on May 25, 2018 by philmodjunk

I've got a small database, just started using it a few weeks ago. As we were starting out, I learned a bit about how to relate records - but we have not been using primary keys/foreign keys to relate records. As we move to using FM 17, I'm looking for advice and guidance on:

 

1) Can I add primary keys (using something Get UUID) to the existing records (somewhere around 200 entries)?

2) If I did that, is there a way to move the current relationship between fields to one using primary/foreign keys?

 

And this is a bit different, but related - is it possible for two different parent tables to have relationship with the same child table?

Outcomes