Formula Fill Timing Issue

[Mark Terry]

On Feb 6, 2008, at 10:50 AM, Ken Doucet wrote:

> I am trying to add fields from one database to another using formula  
> fill
> lookup - syntax generated by system is:
> lookup("CMEMAILV",RECID,RECID,"Valid","",0)  but everytime I run  
> this on a
> 200k table (on an intel macbook pro) it seems to hang and I have  
> forced quit
> after 30 minutes (I have no frame of reference for how long this  
> should
> take). When I assign a new value within the database it takes  
> seconds but
> this lookup is causing me some grief.
>
> Basically, the goal is to expand my 200k table to include the  
> suggested
> corrections from the mailing house so end result would be that I have
> ORIGINALCITY and REVISEDCITY etc in one database so I can verify  
> potential
> impact on end user database before I apply them. I was hoping there  
> was an
> equivalent to a table join that would consolidate into 1 table.
>
> Say Table1 has 12 fields including a RECID field
>    Table2 has 15 fields including a RECID field
>
> Goal Table 1 has it's 12 fields plus 10 of the fields from Table 2.
>
> Appreciate any suggestions

The further the data column is from the key column, and the further  
either of them are from the first column, the longer the lookup( time.  
Since it's so easy to move field positions around in the Design Sheet  
(Cmd-up or -dn), you might consider making them cols 1&2, at least for  
your lookups.

M