I have a table with distance and time and wanted to add a "calculated column" to figure the speed dynamically on forms and in calculations, but haven't found a good way to do it.

First shot was adding the calculated column to the SQL retreival command in the BO, but that never got updated, even after saving a record.

Next I tried adding an "expression column" to the dataset in in the HookPostGetData method of the BO. That got updated when I saved the data, but not before. The displayed value on the form and the value used in expressions in the code did not change until I saved the record.

I tried adding a property to the business entity object, but then I couldn't bind a control to it.

Any suggestions for how to get this to work without saving the record?

...Jim