Hello - I know exactly how to solve this problem using classic VBScript / ASP, but I'm trying to create a nice windows interface (in .NET) using flyGrid. I need direction on how to go about solving this problem, if it is possible with flyGrid. I have tried several different methods (using flyGrid), but all seem to have shortcomings. I have looked at documentation and all support message.
I am trying to display a nested flyGrid. The source of the data is from SQL server, but there is no relationship between the tables.
For example. Table 1 lists students in a class, and the type of pet they like (dog, cat, bird). Table 2 lists pet types, and specific breeds. And table 3 will list the StudentId and the specific breeds they like
Student
StudentId | StudentName | FavTypeOfPet
Pet
PetId | TypeOfPet | Breed
1 | dog | Golden retriever
2 | dog | poodle
3 | dog | mutt
4 | cat | persian
5 | bird | parrot
6 | cat | Aegean
7 | cat | Australian Mist
The goal is to show a nested grid to allow a user to select only the type of animal they like, and have that data populate a different table.
The grid would look something like this:
(sorry - white space is being compressed here)
StudentId | StudentName | FavTypeOfPet
-------------------------------------------------
101 | Guy 25 | dog
PetId | TypeofPet | Breed
-------------------------------------------
[] 1 | dog | Golden retriever
[] 2 | dog | poodle
[] 3 | dog | mutt
102 | Jill Smith | cat
PetId | TypeofPet | Breed
-------------------------------------------
[] 4 | cat | persian
[] 6 | cat | Aegean
[] 7 | cat | Australian Mist
103 | Bob Jones | dog
104 | Sally Fields | bird
105 | Jill Smith | cat
And after updating the checkboxes, the data in table 3 will look like this:
Student_Pet
StudentId | PetId
101 | 2
102 | 4
102 | 7
103 | 3
Thank you.