live lookups?

[Chuck Fussman]

I am using the following code to track agents for our clients:
lookup(info("databasename"),RPID,RPIDAgent,NameFull,"No Agent Assigned",0)

It works just fine. The "RPID" is a numeric code to reference our 
clients in the database. Most clients have an agent, also in the 
database. By entering the RPID for their agent in the field with this 
calculation, Panorama looks up the Agent's name for the viewer.

Here's my question, though. If an agent changes their name (one just 
got married), this field does not seem to automatically update for 
all of their clients. Is there a simple way to update changes like 
this across the database?

Thanks!
-- 
Peace,
Chuck Fussman
RealPro Real Estate & Mortgage
Office: (970) 204-HOME (4663)

"Success usually comes to those who are too busy to be looking for it."
    - Henry David Thoreau
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080714/82d98eb0/attachment.html