3 Replies Latest reply: Mar 19, 2015 9:19 AM by Bill Markham RSS

    lINKING two tables - use two alternative keys?

    Friedrich Hofmann

      Hi,

       

      I have two tables from two different database_systems:

      - In the one (from HR), I have a first_name and name to every employee;

      - In the other one I have a user_logon:

           - That is in most cases made up of 1 letter from the first_name and the name

           - In some cases, however, it is 2 letters from the first_name and the name.

       

      Is there any way I can dynamize the use of either one of these two alternate linking_fields?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler