selected details from list
I have a school database going with tables for Students and Teachers. I have another table to store Notes.
I wonder if there is a way to show the "list" of the people that have a Note associated with them AND
I would like this listing of the people to "expand" to show Notes for only the selected person.
In other words, I have a list of names and when I click on one of them, underneath this persons name, I would like to see the various Notes concerning them. All other Notes remain "hidden".
Is this possible?