9 Replies Latest reply: Sep 20, 2012 2:19 PM by Richard Lowe RSS

    Link Table issue

      Hello, Can anyone please explain how to deail with this key issue? 

       

      Example:

      Table1

        ID1   (primary key)

        ID2

        Value1

       

      Table2

        ID1

        ID2

        Value2

       

      Table3

        ID2  (primary key)

        Value3

       

      Unfortunately in this case I can not join or contatenate the tables.  So I really need to use a Link table.  I attempted to concatenate ID1&" " &ID2 into a link table, which worked fine, but not sure how to now incorporate ID2 from Table3 into the link table without creating another loop.

       

      Here is a picture of the 3 tables before applying any fixes showing the QV created Symbolic links.

       

      Capture.PNG

       

       

       

      Can anyone assist??

       

      Thanks very much.