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.