Including table fields in messages by using different link types

[giubenn]

Hi, we are working on an activity that allows us to insert a link within our messages that carries a pre-filled set of information.
After creating a table with the fields we needed, we added a link to this table in the profile table by opting for the "0 or 1 cardinality simple link" link type, as indicated on the Adobe documentation, and we were able to display and select the fields within our message.
Subsequently, however, we decided it would be more correct to opt for the "N cardinality collection link" type, but we encountered a problem: within our message, we can no longer see the table created and therefore not even all of its fields.
What would the consequences be if we decided to go back to the first link type, i.e. "0 or 1 cardinality simple link"? And also why we can no longer see the table in the message by changing the link type?

[SatheeskannaK · Accepted solution]

@giubenn, There won't be any issues going back to the 0 or 1 cardinality link. You will have to remove the current link that you have and create a new one. Make sure you identify the workflows and stop them before making any changes to the link type. Also, having 0 or 1 cardinality may affect performance. Take a look at the data model best practices documentation.

Now, when you use the custom resource (ex. transactions) with an N cardinality collection link, you don't know how many records (transactions) are associated with the particular profile. Usually, you will have to identify upfront in the workflows on how many linked records (transactions) you want to display in the message will give you the option to choose within an email designer to choose the data to display.