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.

 

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

Outcomes