My only idea would be to perform your calculations using a web based (PHP, CGI, ASP, etc) script to re-evaluate any fields that may need adjusting due to changing data in another field.
I guess it would all depend on the DB, the interface, and options available. The only ones I've worked with have been SQL systems that are accessable to a web-based script.
As far as a field that is automatically updated by the db itself by simply updating another field... I'm clueless. ;)
himerus
Junior Poster in Training
84 posts since Aug 2003
Reputation Points: 11
Solved Threads: 0
Skill Endorsements: 0