I need to update a field in a dBase table based upon calculations performed against several fields in different dBase tables. I can successfully update the table based on equations that use values that exist in the same table.
e.g. UPDATE ''activity'' SET calc_act =id_src*1000
However I need to alter the update sql to use values from other tables.
e.g. Update ''activity'' SET calc_act =id_src*1000*Table2.field.value/Table3.field.value
I need to alter the update to use values from other tables. How do I accomplish this?
I can successfully join the tables using SQL and can display the result set in a tdbgrid. But the result set does not appear to be "live" even though I have requested such. So changes I enter to the grid do not transfer to the underlying tables. Why? How can I make this work?