Jump to content
Sign in to follow this  
smorr

combinations via calculations

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.