Table records with multi sub records

Hi Adam,
Just had a quick look but haven't had time to test it properly (in a rush!!).
Is this what you are hoping to do? (I've done it for students but not for courses).
As always with MVD, other ways of doing it, but this might be one approach.
Regards,
Derek.

Hi,
It's the same principle - the only difference is that the incremental search is already being used to retrieve student details (so you need to add another button to search for the courses and action the 'click' in the script instead).
You were also retrieving the course details when the value in the schools grid was changing rather than when the value in the courses grid was changing.
One more thing - you really need to repeat all your sql calls AFTER you've done an 'edit' as well, because the updated details will not show (try editing some data on either a student record or a course record and you'll see that your changes are not showing - it's different from just issuing a 'dbupdate' command).  It's probably quite inefficient and will make the script rather long-winded (well, you know how I love a minimal script - LOL!).
Anyway, I think it's doing what you want now.
Derek.

I have updated the test project. Please see the attached...

1. I have changed courses table to library so that it makes better sense in respect of what I'm trying to do. Issue of displaying library details of selected school on form1 / School Library tab?

2. Another issue I have noticed. When double click on a record on SCHOOLS tGrid it opens two form; frmSchool and frmLibrary. When clicked on edit button it opens the correct form only. How can we make it to open active tab specific form on doubleclick too? This item is SOLVED thanks to Dmitry's script. However other items are still not resolved.

3. I have tried to use different method (thanks to bemorhona-qt) to refresh records display after add/edit/delete. However, my implementation works partially. On schools tGrid/details only delete refreshes.  On Students tGrid Edit and Delete refreshes but not Add. Perhaps bemorhona-qt could offer a help again?

4. I couldn't find the way to work DateTime component spinbox arrows?

Hello.

Please check out fixed project.

Now you can see library of selected school, also you can edit library.
But if one school can have only one library, you should use one table for school and library. Because if you create two library for one school, which library you should show in tab "School Library"?

Hi Adam,
Meant to follow up on your question but have been tied up.
Rather than have lots of SQL statements to retrieve fields that you want to display, you can do most of it as part of standard MVD. 
Basically, in your script, you automate 'clicking' an edit button so as you scroll through your grid, it retrieves as many fields of data as you want without any additional SQL calls.  And because it is pretty much standard MVD, there should be no issues with refreshing and updating.
Have a look at the attached project and it might give you a different approach.
It's something I did a while back but I've changed some of it to be relevant to your question.  I use panels instead of page controls / tab sheets but the principle is identical and there is a mix of data coming from both the main and the related tables.
Although there are a few lines of code in the script, 95% of it is either cosmetic or to safeguard against the user creating duplicate rows (because it's all on one form).
Hope it helps,
Derek.