468,525 Members | 2,196 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,525 developers. It's quick & easy.

Parent-Child DataRelation among 3 tables

Hi,

I'm new at vb .net and I have an issue that must be a common one, but I
haven't found an example of it yet.

I want to create parent-child relationships for 3 tables
(grandparent-parent-child?). I'm trying to create a contact management
app. My 3 tables are Company, Contacts and Results. All 3 tables will
be bound to datagrids-- when you click on a company (first datagrid)
you should see the list of contacts for that company in the second
datagrid, when you click on one of those contacts you should see a list
of results from calls made on that contact in the 3rd datagrid.

I can get the relation with the first 2 tables to work fine-- click on
a company, see that company's list of contacts. But I can't get the
filtered "Contacts" to work with its child table.

Hope someone can help me with this; thanks in advance.

Michael Kidd
mi******@volkcorp.com

Nov 21 '05 #1
2 1909
Hi,

www.onteorasoftware.com/downloads/multigrids.zip

Ken
-------------------
"mkidd" <mi******@volkcorp.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Hi,

I'm new at vb .net and I have an issue that must be a common one, but I
haven't found an example of it yet.

I want to create parent-child relationships for 3 tables
(grandparent-parent-child?). I'm trying to create a contact management
app. My 3 tables are Company, Contacts and Results. All 3 tables will
be bound to datagrids-- when you click on a company (first datagrid)
you should see the list of contacts for that company in the second
datagrid, when you click on one of those contacts you should see a list
of results from calls made on that contact in the 3rd datagrid.

I can get the relation with the first 2 tables to work fine-- click on
a company, see that company's list of contacts. But I can't get the
filtered "Contacts" to work with its child table.

Hope someone can help me with this; thanks in advance.

Michael Kidd
mi******@volkcorp.com
Nov 21 '05 #2
That's exactly what I was looking for! Thanks!!

Mike

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Zürcher See | last post: by
2 posts views Thread by Jeronimo Bertran | last post: by
6 posts views Thread by Ray Schumacher | last post: by
2 posts views Thread by Steven | last post: by
4 posts views Thread by Andrew | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.