I migrated an access database into SQL Server Management Studio now I am trying to recreate forms using K2 Smartforms. In one of the item views I choseĀ a multi-select control and linked it to a smartobject that stores the data. I need the selected items to store in another smartobject which saves to a sql table. For some reason I can't get it to work. The item view is for data entry and the multi-select control on the item view comes from a different table which has a relationship with two other tables in sql. When I test the item view which is a form now does not save the information to the table to the related table IĀ need the data stored in. I have been playing with the conditions, rules and actions. I may be selecting the wrong ones. I was trying to avoid adding a specific column in the sql table to get this to work the way I need. Any suggestions or help is greatly appreciated.
Best answer by paulk
View original