3 Replies Latest reply: Aug 3, 2012 10:22 AM by davidsimm RSS

    2 Fields in table A linking to 1 field in table B

      Hello,

       

      How can I achieve this?

       

      I have 2 fields in Table A:

       

      Specialty_code_start as specialty_code

      Specialty_code_end

       

      and 1 field in Table B:

       

      specialty_code

      specialty_desc

      specialty_local

       

      How can I get Specialty_code_end to link to the same Table B?

       

       

      Thank you