6 Replies Latest reply: Jun 16, 2010 6:25 AM by umangu2000 RSS

    Getting data from two different tables using matching field values



      I'm stuck with a problem and cant seem to be able to solve it [:$]


      I have got two table one which has details of the Company as its Name, its sector and the name of director. The other has details of the director who has experience in various industries as Name, Sector & Experience.


      What i want to be able to do is find the experience of the director in the sector of the company.


      I have attached a QV as example and as a solution I want

      For company ABC in the Finance sector, the experience of Mr X the director ( who has experience in Finance, Power & Industrial sector) should be shown as 5 (relevant to Finance sector)