Logic confusion (Lookup)

[Groover David]

I have a lookup question. Perhaps the correct answer is, "why are you  
doing it that way?". I am trying one of two methods I can think of  
and I am missing it other wise.

Problem: I have an array of Todo tasks that I show in my contact  
manager. This array gets built using an arraybuild which focuses on  
my calendar program to pull active todo events into the array. I am  
redoing this as I didn't have a need for printing a paper todo  
schedule, and now I do. Obviously it would be one solution to simply  
have all new todo events add the contacts phone number from the  
beginning. But I still have several tasks with no phone numbers. I  
thought it would be pretty easy to use a lookup in the arraybuild to  
append each todo contact's phone number to my new printed list of tasks.

Which brings me to this problem. The arraybuild is using the calendar  
DB to pull data into an array that is displayed in the contact  
manager DB. But, the lookup I Need, needs to remain inside the  
database I am taking the array from. So, am I really missing  
something simple here? The below example works, except there is no  
First or Last field in the Calendar, that is looking only in the  
current DB. Is there anyway to do this, or should I just redo the  
half dozen or so todo events and make sure the calendar DB has a  
contact phone as well as a contact or organizational name?

Yes, I can see my logic is messed up here, that is why I am posting  
this. IF the arraybuild is focused on the calendar DB and within that  
arraybuild I try to use lookup and info("databasename") points to the  
current DB (Contacts DB) then .. how should I look at this?

lookup(info("databasename"),(First+" "+Last),(array(strip 
(CalContactname),1," ") +" "+array(strip(CalContactname),2,"  
")),"Phone1","",0),"")


Thanks

David Groover