AnsweredAssumed Answered

designing a database for PairWise comparison

Question asked by Ernest on Mar 8, 2013

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.




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