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?