I have 2 different smartobjects which I would like to use for emailing purposes. One for customer, and one for recipients, where the recipients smartobject has: RecipientID, RecipientName, EmailAddress and CustomerID (Foreign Key). Customer is CustomerID, CustomerName.
In my smartform I'm using a multiselect on the Customer SmartObject which looks at the CustomerName and returns the CustomerID.
I want this to then populate another multiselect to return all Recipients that are associated to the CustomerID's returned in the first multiselect.
However, when doing this with more than one customer, I'm unable to populate the Recipient List as I get an error because of the ; delimited list selected in the first part is seen as an nvarchar and not an int.
I'm currently using a work around which isn't best practice with relational databases, I'm using one large smartobject consisting of the CustomerID, CustomerName, Email Addresses. The email addresses field consists of a large list of all the recipients associated to the customer which is saved as a memo field in the smartobject. I can then return all the email addresses associated to the customer but unable to edit an individual recipient as they are part of the long list.
Does anyone have a work around for the initial issue?