So I have a DataGrid question, needing some input.
I have a database set up with Clients and Accounts. There are X
number of clients. Each client has Y number of Accounts. Client
one can have an unlimited number of accounts and so on.
When I load a DataGrid with Clients, I'm looking to have something
similar to what you see in MS Access. In Access, if you have
clients, and they're linked through a relationship to accounts. If
you load Clients, there's a little + sign signifying more info, you
expand that row, and rows pop up below showing Account rows
associated with the current client.
Sort of a visual below:
Closed Row:
+ Client ID | Client Info | Notes
Open Row:
- Client ID | Client Info | Notes
Account ID | Account Info | Client ID
Account ID | Account Info | Client ID
Hopefully this all makes sense and someone can point me in the
direction I'm looking to go. Any help would be good! :D
Thanks-
Nathan D.
