<div>
Thanks, I had looked at XpertSS.com before, but not closely enough. &nbsp;<br />
I found a solution on the site which I am about to try.
</div>


Thanks, I had looked at XpertSS.com before, but not closely enough.  
I found a solution on the site which I am about to try.

<div>
jtwomack,<br />
<br />
Excellent finding - let's hope it does the trick. Thanks for the points.<br />
<br />
Patrick
</div>


jtwomack,

Excellent finding - let's hope it does the trick. Thanks for the points.

Patrick

<div>
<div class="content wysiwyg-content">
I have a nice little Lotus Approach database with many relational lookups to do calculated fields. &nbsp;Rather than creating more relations to keep related &quot;calculated fields&quot; in sync when the underlying tables are changed, I need to create a &quot;macro&quot; or &quot;script&quot; to recalculate with the push of a button. &nbsp;Surprisingly, I have not found an example of this in the any APR files I have checked. Can anyone point me to a good example (or provide one)?
</div>
</div>


I have a nice little Lotus Approach database with many relational lookups to do calculated fields.  Rather than creating more relations to keep related "calculated fields" in sync when the underlying tables are changed, I need to create a "macro" or "script" to recalculate with the push of a button.  Surprisingly, I have not found an example of this in the any APR files I have checked. Can anyone point me to a good example (or provide one)?

Update calculated fields from related tables

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.