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 ?