We are trying to use the grid with embedded detail grid when the use opens the selected line, but want to load just the detail data for the opened master record that is related to the detail.
So when the user opens master line 1, it loads the data for detail of line 1, then when they open master line 2, it loads the data for that master's detail grid.
I can find how to filter all the details for all masters, but if we have hundreds of masters with thousands of related detail records, we don't want to load all those.
Is there a way to assign a different data set to each opened detail grid?
Thanks for any ideas