Frans,
Is it possible to update a field with the values filtered from another table using UpdateEnttiesDirectly?
I have two tables with 1-m relationship.
I want to update field in table2 with some filter condition, with values in table1's field, with some filter condition
In SQL:
Update table2
set field1=(select MyField from table1 where table1.someField=someValue)
where table2.someField=SomeOtherValue
Thanks
Gabor