troubleshooting Question

Two Datagridviews with Master-Detail relationship

Avatar of crickpaolo
crickpaolo asked on
Visual Basic Classic
3 Comments2 Solutions290 ViewsLast Modified:
Hi,

I need to create a Visual Basic windows form with two datagridviews that shows data for the following tables:

Table: Employee_Table
PrimaryKey:  Employee_ID (GUID)
Fields: Last_Name, First_Name, Address

Table: Dependents_Table
Primary Key: Dependent_ID (GUID)
Fields: Employee_ID (FK), Dependent_Last_Name, Dependent_First_Name, Relationship

The first datagridview should show the contents of the Employee_Table. When I click on a row on that datagridview, I want to related Dependents_Table record to show on the other datagridview.  

How do I do this? I am using Visual Basic 2005. And SQL Server 2005.

Thanks.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros