Lookup Calculated Field

I have to lists in my sharepoint. One is a list of contacts (not
belonging to the sharepoint) and the other is a log of items they can
be associated to. Right now there is a lookup column in the log for
users to pick the last name of the 'contact' they want it associated
with. Suddenly, we have two contacts with the same last name
(bummer). I created a concatenated column in the contacts list to join
the first and last names into one field, however when I go to create a
"lookup" column in the log, the calculated field does not appear as an
option for its source. I can't for the life of me figure out how to
fix this. Any ideas?

-Christine

.

Relevant Pages

  • RE: Excel SharePoint 2003 Integration
    ... I was using SharePoint 2 and now I upgraded to SharePoint 3. ... Synchronize an Excel list with the SharePoint site ... Unlink the lists ...
    (microsoft.public.excel.misc)
  • Re: Microsofty Sharepoint dll viewed in Object browser
    ... The web services are available from the server. ... SharePoint Services, such as for creating or deleting sites. ... Lists Provides methods for working with lists and list data. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Persist user information using only out-of-the-box web parts
    ... Custom lists and the Data View Web Part will do everything you need -- In fact, your example is one that's taught in the SharePoint Bootcamp (link in my ... I wanted to have each user only change the XML portion of the web part, ... Can't create a custom web part (real easy to retrieve the user information in the tool pane). ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Problem with Access and linked List in Sharepoint
    ... Thanks for information Albert. ... I get the message that the Sharepoint version of the database is no ... except the additional columns added to the Lists. ... The simple solution here is to build a query with the only the columns you ...
    (microsoft.public.access.externaldata)
  • Re: Some dumb questions
    ... All AD users becoming members of the portal - how is this done? ... > sharepoint 'member' group but sharepoint didnt seem to like this... ... > "Customize Lists" link on the left and one doesn't. ...
    (microsoft.public.sharepoint.portalserver)