Formula Fill Timing Issue

[Ken Doucet]

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

Thanks

Ken

P.S. How do I respond properly to keep thread links going. Is it just by
keeping subject header identical? I want to respond    to keep thread flow
correctly.