Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
show in the ExternalList column Firmaname instead of FirmaID

Unanswered show in the ExternalList column Firmaname instead of FirmaID

  • Monday, June 14, 2010 1:12 PM
     
     
    Sign In to Vote
    0

    how to change in the externallist the column from

    I would like to show instead of the one column FirmaID of the entity one other column Firmaname:

    I have 2 tables: Contact and Firma. They have the 1:n relation. Connected by FirmaID. If I create the List I have got FirmaID column. I have created an association to Firma table. I  select the FrimaID from the Firma table it's OK. But I would like to show in the List column Firmaname instead of FirmaID

    ContactID Name FirmaID
    1 Jimmy 1
       

     

    Thanks in advance

    Sebastian

     

All Replies

  • Thursday, June 17, 2010 6:53 AM
     
     
    Sign In to Vote
    0

    Hi Sebastian,

     

    Could you tell us how many columns does each list have? How does the new list look like?

     

    I recommend that you look on this solution http://www.sharepointboost.com/Cross-SiteLookup.html.

     

    Alternatively, you can use BDC column which is requested data from your list, depending on selected ID.

     

    Hope this is helpful to you.

     

    Rock Wang

    Rock Wang– MSFT
     
  • Monday, June 21, 2010 1:24 PM
     
     
    Sign In to Vote
    0

    I would like to use the following steps:

    I have 2 Tables:

    >>first Table:

    *ContactID

    FirstName

    LastName

    FirmaID

    >>second Table:

    *FirmaID

    FrmaName

    Address

    If I create an asociation with sharepoint designer and I let user select the FirmaID from Table Firma I would like to display in the Column Firma FirmenName instead FirmaID. Hier a picture.

    [URL=http://picfront.de/d/7GnX][IMG]http://www7.picfront.org/picture/Jjl1oipSHNz/thb/FirmaIDFirmaName.png[/IMG][/URL]

    http://picfront.de/d/7GnX

    Sebastian