combinations via calculations

[smorr]

Hello, I am working on a fairly complex events calendar where I am using complex compound keys. One of the keys I need however needs to be the combination of two fields, regardless of the number of keys in each field. For example:

alphaField:

A

B

NumberField:

1

2

CombinedKey that should result from calculation:

A1

A2

B1

B2

however, substitutions will not beable to get all combinations possible. For example, I can get

A1

2

B1

2

If worst comes to worst, I will have a script generate the key but I rather have it more automatic.

If anyone else has dealt with the same problem I would love their input.

Thanks

Scott

[Vaughan]

Can you come up with a (simple) set of rules that defines the do-able combinations? I suspect that will be the hardest: the actual FMP programming is usually straight-forward.

[djgogi]

Hi here's an example file (check the attachment)

Dj

TextMultiplication.fp5.zip