Hi Everyone,

I was hoping someone had a calculator or Custom function that would calculate and list all the combinations of a 7 key field foreign key calculation field.

I have found some calculators on the internet but none that will do exactly what I need.

What I am hoping for is the ability to list the 7 fields and the blank/empty field (8 total fields) and have the calculator generate a list of all combinations that I could then copy/paste into my calculated foreign field.

**The combinations will maintain this field order**

The primary key calculated would look like this:

__kp_g_FilterItemClass1& __kp_g_FilterItemType1& __kp_g_FilterColor1&__kp_g_FilterSeason1& __kp_g_FilterPerson1& __kp_g_FilterItemSize1& __kp_g_FilterGender1

The calculated foreign key would start with:

_kf_ItemClass & _kf_ItemType & _kf_Color &_kf_Season & _kf_Person & _kf_ItemSize & _kf_Gender

Next line would include the empty value field in the first position:

_kf_EmptyValueField & _kf_ItemType & _kf_Color &_kf_Season & _kf_Person & _kf_ItemSize & _kf_Gender

Following this pattern, and if my calculations are correct I will end up with 128 lines of combinations.

Can anyone help with this?

here is a link to calculator/value generator that almost works:

http://textmechanic.com/Permutation-Generator.html

thank you

Robert Bloomfield

What are you hoping to achieve with the result of such calculation?