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:




      CompanyID | a bunch of other info




      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.