AnsweredAssumed Answered

How to create combinations?

Question asked by mwtse on Jan 14, 2010
Latest reply on Jan 15, 2010 by mwtse


How to create combinations?


Say I have a table containing five records: John, Kitty, Paul, Peter, Mary (one for each person).


How could I create all the combination between them?


John - John (will have to ignore but this should be easy)

John - Kitty

John - Paul

John - Peter

John - Mary

Kitty - John

Kitty - Kitty (ignore)





The final result I want to have is to pick out two person and compare their data. I remembered that in SQL, there is a way (self-join ?) to produce a two-dimentional table I needed (i.e. Field1 contain one person, Field2 contain another, if there is 5 person, the table will have 5 x 5 = 25 records). However, I could not figure out where and what to search for with FMP 10.