VS 2008 DataGridView - DataSet With 2 Tables And Relationship

I'm going to describe this as simple as possible, and it a typical setup for a database...

I have 1 DataSet, 2 DataGridViews (DGV), and 2 BindingSources (BS).
The DataSet has 2 tables and 1 Relationship (FK).

Table 1 is a employee table
Table 2 is timeclock data.
Both tables contain a column: EmployeeId

FK is linked to EmployeeId of both tables.

DGV1 has it's datasource=BS1
BS1 has it's datasource=DataSet and it's DataMember=Table 1.
Thus DGV1 shows Table 1.

DGV2 has it's datasource=BS2
BS2 has it's datasource=BS1 and it's DataMember=FK
Thus DGV2 shows Table 2 filtered by what's selected in DGV1.

Now when I use the mouse or keyboard to select a cell in DGV1, the relationship causes DGV2 to update to only show data from Table 2 where the EmployeeId row equals that from the selection in Table 1. With me so far?

Well all that works great. But what if I need to programmatically select a row in Table 1 to cause Table 2 to update? I've tried everything I can think of, but Table 2 NEVER updates when I attempt to programmatically select a row or cell in Table 1.