0 Replies Latest reply on Mar 8, 2013 6:48 PM by Ernest

    designing a database for PairWise comparison

    Ernest

      hi there

       

      I'm new to this forum. been a FM user for a long while, now build my own solution.

       

      in a project, I apply a PAIRWISE COMPARISON and check priority on ABCD... criteria per user. in Excel it is just individual tables of priority then summarise all tables into average.

       

      user001ABCDsum
      AAACDA=2
      BBBDB=2
      CCCC=3
      DDD=3

       

      in FileMaker Pro, I want to identify TWO properties :
      1) priority, in rank
      2) preference, for example, while user choose C in the pair of AC, what other choices had been made

       

      question - how should I design this databse ? the pairwise table as a table entry, or the pairwise table as a record to a user ?

       


      thanks, Ernest