I need to create a Visual Basic windows form with two datagridviews that shows data for the following tables:
PrimaryKey: Employee_ID (GUID)
Fields: Last_Name, First_Name, Address
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.