I'm creating a DataRelation between two datatables of a single dataset. One
of my relationship columns is a string field and I notice that the
DataRelation is case sensitive. Therefore, If my parent table contains a
record in with a value of 'name' only records in my child table with the
value of 'name' will be included in the DataRelation. If the child table has
a record with a value of 'Name' this will not be seen or included in the
relationship.
Is there any way to turn off case sensitivity in the Data Relation? I've
gone through and set the CaseSensitive property of the dataset and all it's
individual datatables to false before i apply the data relation and that
doesn't seem to work. Any help is appreciated.
Thanks,
-Rick