I'm working in Visual Studio 2005 Team Edition for Software Developers.
I have 3 tables defined in the DataSet Designer, and a DataRelation between
each table. The user sees a each of these tables on the UI, such that if the
user clicks a different row in Table 1, then the data displayed in Tables 2-3
change. This all works great.
The user can click on rows in Table 1 where the relationship columns are
empty. Table 2 displays all empty rows, which is exactly what I would expect
to happen. The problem is that Table 3 does not update - it just continues to
display what was previously there.
The wizard created binding sources between the tables. Any suggestions on
how to enforce binding source chaining through all the tables using code
(rather than the wizard)?
Finally, I thought this was going to be as easy to going into the DataSet
Designer, editing the relationship line, and changing the "Relationship" to a
"Relationship and Foreign Key Contraint," then set the "Update Rule" to
"Cascading." The problem is that Visual Studio crashes every time I try this.
Anybody ever have that experience?
Thanks,
Randy