live lookups?

[Bruce De Benedictis]

When I want a live lookup, I put the lookup code in a form, rather than
saving it as data.

Bruce De Benedictis

> 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!