1 Reply Latest reply: Oct 31, 2013 11:36 AM by Clever Anjos RSS

    Generate same key in different tables based on 2 fields

    David Koschei

      Table1 has fields T1.FieldA, T1.FieldB, Count1

      Table2 has fields T2.FieldA, T2.FieldB, Count2

       

      I need to keep the tables separate because I don't want the counts to inflate, but how do I join the two tables on fields A and B?

       

      I could create a link table, but I would prefer to make a compound key.  Since one of these fields is text, I was wondering if there is some function that will translate the combined FieldA+FieldB to the exact same integer in both tables.

       

      Thank you