Parent-Child DataRelation among 3 tables

M

mkidd

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
(e-mail address removed)
 
K

Ken Tucker [MVP]

Hi,

www.onteorasoftware.com/downloads/multigrids.zip

Ken
-------------------
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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top