Sorting Child Tables in a Data View

[Hemang Shah]

Hello folks

This seems relatively quite easy but I cannot put my finger to it.

I have a form with 5 tabs.
I also have a dataset with 5 tables, (1 parent with 4 child).

I have a data View of the dataset which is bound to the form.

So my form has a listview, with first name & last name (in that sort order)
so that they can be easily found.

now on each tab, the records are sorted as they are entered (I guess by id).

But what I want is, each tab, (which is bound to its respective child table
which is in the same dataview), to be sorted based on another field.

I can easily create another dataview and bind, but then I lose the binding,
and when a record is changed on the main form, the records will not be
changed in the tabs.

So how do I do this ?!

Thanks

 

[Andrew Conrad]

Creating dataviews for the child table with the desired sort should work.
It is unclear to me why you think it will not.
Perhaps some code samples would help.

Andrew Conrad
Microsoft Corp