Newbie question re synchonizing address lists (Ken Doucet)

[David Thompson]

>
>
>I have been following the math/formula fill to populate content of field
>with values from another table using:
>
>lookup("CMEMAILV",RECID,RECID,Valid,"",0) and then wait..... At this stage I
>am trying to populate 1 field from CMEMAILV but I will need to do several. I
>waited 40 minutes and still nothing - my apple activity monitor is showing
>cpu around 100% and Panorama not responding in Process column(I am on
>macbook pro intel) and the colour wheel is spinning .
>
>This is giving me more grief than I would have expected as all I am trying
>to do eventually is join 2 tables so that I have the original address fields
>along with the revised ones coming back from mailing house so I could
>analyze them.

Doing a formula fill in one very large database, that does a lookup 
in another very large database is something Panorama doesn't do very 
well. The time it takes is proportional to the product of the number 
of records in the two databases.

I would append the data from one database to the other and then use 
the RECID field to sort the database. That would put the data with 
identical RECID values into consecutive records.

The database that is receiving the import would have additional 
fields for the data that will be imported. The names of the fields in 
the database the import is coming from should match the names of the 
fields you want to receive that data. The RECID field would have the 
same name on both databases, so that you can do the sort. After 
importing and sorting, you can use propagate to consolidate data with 
the same RECID value onto the same records.

>
>Thanks
>
>Ken
>
>PS how do I respond so that this will flow into thread (is it just by
>keeping subject line identical? I wanted to reply to Michael's response to
>my first post.

If you are referring to the thread view in the archive, that thread 
is determined by the In-Reply-To: header, not the Subject: header. 
That's probably also the way that Outlook is keeping your threads. If 
you are a digest subscriber, it might not be possible to get your 
reply to be considered part of same thread. If you aren't a digest 
subscriber, you would do it by replying to the email, rather than 
composing a new one.

Dave