Combinations

[PotzUK]

What I'm after is a calculation which will give me all the combinations of 5 fields...

Eg.

Field 1 = A | Aa | aa or A -

Field 2 = B | Bb | bb or B -

I need an output which:

A, B

Aa, B

aa, B

A -,B

A, Bb

A, bb,

etc

Does anyone have any ideas?

TIA

Tony P

[Factory Pilot]

Does the field have just one of each of the values in it? (e.g. "A" or "aa")

Or does the field have multiple values in it separated by something? (e.g. "A | Aa | aa | A-"

[Garry Claridge]

Perhaps you could use a script to create an output/display field. The script could loop through each field and concatenate each element in the required order.

All the best.

Garry

[PotzUK]

I have 10 fields in total, but only two fields in each 'block'

E.g.

Field A + Field B, Field C + Field D, Field E + Field F

Each field has a total of four different values (from a value list).

The end result is a breeding gene predicter...

Tony

[Garry Claridge]

Here is a solution with the following assumptions:

Fields are:

f1 to f10 of type text and are repeating with a value of 4.

b1 to b5 of calculation, example for b2 (block2) is:

GetRepetition(f3, 1) & "," & GetRepetition(f4, 1) & "