The form has 5 data sources with TempDB tables which are not joined to each other. The data source data is displayed on 5 separate grids.
When the form opens, the data needs to be populated on the form. There is a custom Save button and clicking on it, data needs to be copied from all of these individual data source and stored in a seperate regular table one for each of these tempdb datasources. The save can happen multiple times and data can be stored in the table for every new version which is unique by a number.
there is another form control with drop down on these versions. when a user picks a specific version the data needs to be loaded on the form for that specific version.
I am adding code to populate the temp table on modified event and calling research method. But the data on the form does not reflect on what I populate in code, eventhough I populate the datasource for that specific version.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.