MultiSelect Lookup Should store value as 'Value1;Value2'.

Finance and Operations/AX Developer Forum
1

Hi All,

I want to create MultiSelect lookup for one bounded field in a form. The lookup should shows the List of companies where I should able to select more than one company, after selecting it should store the selected values as ‘company1;company2’.

Please suggest me the possibilities in AX, I have seen one example for MultiSelect lookup with unbounded control.

Please tell me how can I achieve the same for bounded controls.

Thanks

2

Any suggestions…?

3

Storing values like ‘company1;company2’ would be a horrible database design (it violates already the first normal form) with severe consequences. For instance, you wouldn’t be able to index values inside the field, therefore you would either never find “company2” in your example or you would always have to perform a full table scan. You would have problems with values containing comma. You don’t know how long the field would have to be, because it depends on the number of values.

You can avoid all these problems by designing your database schema properly. Use a table to store the list of companies.