0 Replies Latest reply: Nov 29, 2012 5:20 AM by Razor Ramon RSS

    What's the best way to resolve this synthetic key problem

      Hi all,


      Very straight forward question. I have two tables with three common fields. What is the best way to resolve the synthetic key that would be formed


      1. I could rename the fields in one of the tables or

      2. I could create a composite key of the fields in both tables so that they associate on this instead.



      Which is the best way and why?



      Many thanks