[RESOLVED] DataColumn.Expression

[enex]

Hi, I'm wondering if its possible to evaluate fields from more than one table with the DataColumn.Expression property

e.g Table1.Field1 <= Table2.Field5

I dont really want to carry the extra fields in the first datatable thats all.

Cheers
enex

[honeybee]

It's possible if the two tables are related. To refer to the parent table from within the expression of a child table column, you can use the word "Parent.FieldName", while for vice versa you will have to use the relation name.

.