3 Replies Latest reply: Apr 30, 2013 2:12 AM by Vishwaranjan Kumar RSS

    Modeling n:m relationships in QV

      Hi - apologies if this has already been discussed at length (I would imagine it being a pretty common question, but didn't see anything obvious on a search of the forum)...

       

      I have 2 logical tables:

       

      Companies

      ----------------

      CompanyID | a bunch of other info

       

      Partnerships

      ------------------

      CompanyID | PartnerID

       

      The Partnerships table is a standard n:m linking table. Both CompanyID and PartnerID should match Companies.CompanyID. What is the best way to model this in QV. I did the default "generate CSV for both of these and just see what happens" thing, and noticed that QV created a synthetic key for what appeared like joining on both CompanyID and PartnerID - and I'm pretty sure this is not what I want. Any pointers or links to resources are greatly appreciated.

       

      _howard