thehand6

ok that help , but i had to put the wrt#'s into two repeating fields, then use a script to get them to rotate for every round.. rnd1... rnd2... rnd3 ... 1-2... 1-3... 1-4 ... 3-8... 4-2... 5-3 ... 4-7... 5-8... 6-2 ... 5-6... 6-7... 7-8 ... and for odd # of wrestlers I used a "Bye" rnd1... rnd2... rnd3 ... 1-2... 1-3... 1-4 ... 3-7... 4-2... 5-3 ... 4-6... 5-7... B-2 ... 5-B... B-6... 6-7 ... I used a couple CF's to get it to work.. NumRange( From ; To )by Ray Cologon // to get 1¶2¶3¶4¶5¶6¶7¶8 MinValue( list ; value )byTheo Ros // find the middle value in the range list Reverse( text )by Andrew Persons // reverse list2 list ...9¶8¶7¶6 CombineValues( list1;list2;devider )by Jonathan Stark //combine both list 1-8 2-7 3-6 4-5 ExtractLine( Field; Number)by Michael Haymore // used to extract the wrt# from the list now there has to be away of puting this all in one CF ... any ideas?

Hello all, I would like to know if anyone can help .. I have a wrestling app. in fmp8 that assigns a unique # based on the number of wrestlers within a wht-class... (5 wrestlers in wht-class 125lb) so wrt#1 wrt#2...... wr#5. Now heres the tricky part... i want to use a custum function to show a list of every wrt# and match it up with every wrt#, without any repeats or matching itself.. 1-2 3-4 5-Bye 2-3 4-5 1-Bye 3-5 1-4 2-Bye 1-5 2-4 3-Bye 2-5 1-3 4-Bye I know there are some functions CombineValues( list1, list2, divider ) that combins all values in two lists but they have repeats and match ... ( 1-1¶5-5) (2-4¶ 4-2 ).. but that will not work in my case.