5 Replies Latest reply: Nov 19, 2015 10:30 AM by Joanna Seldon RSS

    Linking Fields

    Joanna Seldon

      Hi

       

      have issue

       

      i have concatenated 1 & 2  tables, as they have similar fields , except 1..

       

      Table 1 - Orders

      Table 2 - Delivery

       

      Table 1 - Department - example Catering

      Table 2 - Dept - example  CAT

       

      I need to link these but having an issue

       

      i have left join a Table 3- DepartmentLink

       

      Department - example Catering

      DeptCode as Dept - example  CAT


       


      is there a way of if CAT is found rename as Catering so a link is made?

       

       

      please help