I would like to be able to create a list (concatenated field) of all possible combinations of a series of 4 dropdown boxes.

So for e.g.

DropDownList 1: A, B
DropDownList 2: X, Y

Would like to be able to generate the following list:

AX
AY
BX
BY

Any and all help would be appreciated.

Thanks
Tannia