--- "Woodard, John" <[EMAIL PROTECTED]> wrote:
> Philip,
>
> I'm having trouble understanding your example given that I don't how your
> tables and records are layed out, so I can't complete the mental diagram.
Ah the beauty and horror of cut and paste ;-)
> It looks like mapData is the parent, but is recordType a member of a child?
>
> On a broader scale, does anyone know of a more complete reference for
> expressions?
This is hard to find. I seem to remember running across info searching
newsgroups but it was a long time ago.
I fleshed out the example a little, guessing on what your terms might have
been.
This untested example would filter the colors to those for the given person.
string personName = "Jon Doe";
string autoRelation;
string childFilter = "";
DataView view = peopleDataSet.ColorTable.DefaultView;
DataRelation relation = peopleDataSet.Tables["People"].ChildRelations[0];
if (relation != null) {
autoRelation = relation.RelationName;
childFilter = "Parent(" + autoRelation + ").Name = '" + personName + "'";
}
view.RowFilter = childFilter;
