Sorting Data in 6 Fields (Columns)
Could FM Pro experts please help me with the following:
I have Fields (Columns) A, B,C,D,E,F with data. I have to sort these datas into Fields (Columns) M,N,O,P,Q,R in
ascending order in a Row.
eg Fields: A=200, B=300, C=400, D=100, E= 600 F=500
I have to obtain the following results in Fields M,N,O,P,Q,R in ascending Order
ie. M=100, N=200, O=300 P=400, Q=500 R=600.
How do I set the calculation formulae in Fields:M,N,O,P,Q,R?
Many thanks in advance.
I would move the data in fields A, B,C,D,E,F into a related table of records. Then you can sort the related records into the ascending order you specify quite easily.