live lookups?

[Kurt J. Meyer]

Am 15.07.2008 um 00:17 schrieb 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?

Chuck,

you keep clients and agents in one database. So you have to select  
records with the old name of the agent and do a Fill in the name field  
with the new name.

You could make that easier, if you would separate clients and agents  
into two databases. That is what lookup typically is meant for: To  
lookup information from a field in a second database if a ID  
(contained in both databases) matches.

Then you would have only one record with this agent's name in the  
Agents database, and it would automatically displayed correctly in  
your Clients database, when the name has changed.

Kurt


-- 
Kurt J. Meyer
Cologne, Germany

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080715/0bbf6f4c/attachment.html