I know many developers steer clear of using repeating fields but they come in handy when making multi key relationships.
I would like to make a repeating text field that auto populates emails.
customer table has 3 emails, Email1, Email2, Email3
I would like the repeating calc to simply place Email1 in repetition1, Email2 in repetion2, Email3 in repeition3
I use this to make a relationship to an Email Management system where we store our bad emails./opt out emails, etc..
This single relationship would be far more efficient in evaluating emails in the Customer table.
Can anyone show me an example of how this calc may be written?