Hi,
I need to query the table using the selected record of canvas 1 and need to populate reocrds in canvas 2. Like if I have 10 records in my canvas 1, for each and every record in canvas 1, have to fetch some date from the table and the canvas 2 should be populated with the fetched results. At a time Canvas 2 should show the value for the current selected record of canvas 1. And finally on clicking OK button on canvas 1, the records of canvas1,canvas2 should get saved into tables.
Both the canvas exists in the same form.
For me only the last reocrd is getting inserted into the table(canvas 2). Which means the data is getting over-write whenever the canvas 2 is called by loop. The program is clearing the data from canvas 2 of the 1st record (selected in canvas1) when the loop comes on the 2nd record (selected in canvas1) to populate the data in canvas 2.