1 Reply Latest reply on Apr 4, 2010 2:32 AM by comment_1

    Selecting related data from multiple tables

    sscotchm

      Title

      Selecting related data from multiple tables

      Post

      I am brand new to FileMaker but have programmed in SQL, Oracle etc. However I can't seem to work out how to do a simple table lookup. Can anyone point me in the right direction.

       

      Example would be.

       

      I have an "answer" table where the records look something like this.

      Respondent: Steven

      Question1: Agree

      Question2: Agree

      Question3: Disagree

      etc

       

      I then have a "weighting" table where the answers are related to a number.

      Agree: 100

      Disagree: 40

      No Opinion: 0

       

      On a report layout I am trying to look at an individual "score". Eg In the example above I want to show that Steven had a score of 240 - being for 2xAgree an 1xDisagree. I need to work that out on the report.

       

      I know how to do it with sql queries. Can anyone help me with the equivalent lookup and calculation entries in filemaker?

       

      Best Regards

      Steve

        • 1. Re: Selecting related data from multiple tables
          comment_1

           


          sscotchm wrote:

          I have an "answer" table where the records look something like this.

          Question 1 Agree

          Question 2 Disagree

          Question 3 No Opinion

          etc


           

           

          I am assuming the example shows 3 records of the Answers table - otherwise you have a serious structural probem.

           

          Define a relationship between Answers and Weighting, matching on answer.

          Define a calculation field in the Answers table = Weighting::Number.

          Use a summary field in Answers table to total the calculation field.