Table to Table update

[Kerry Bugger]

Could some tell me how to update a field in one table from a field in another table. A simple add or subtract.

Thanks

[Stan Mathews]

If memory serves you can create operations, one type of which is an update?

Create a set with the table you want updated as the parent linking on some common field to the other table. Define the update operation for this set.

You should also be able to define a posting operation from table to table which might meet your needs (no set required).