Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

doing "lookups" to return the value of more than one column

Asked By: Scot Lott Date: Mar 13, 2007 Category: MOSS Views: 487

I am trying to create several lists that all have several columns in
common. Is there anyway to do a lookup to one column and pull back
multiple columns. For instance: I have a "clients" list with Client
name, client number, address etc now I am trying to create
a "Contacts" list that retains all of this information but then also
allows you to edit it (if need be) and also enter additional columns
and information. I would consider this a parent:child relationship. If
the clinet name changes on the parent it would also need to change on
the child. I am using SharePoint07. Any good pointers would be helpful.

Tagged:doing lookups to return the value of more than one column

3 Answers Found

Answer #1 Answered By: Octavio Dotson Answered On: Mar 13, 2007

WSS lacks robust relational list support. This is one of my top three
platform busters:

1. Large List Support
2. Relational List Support
3. OLEDB Reporting

Answer #2 Answered By: Judy Pittman Answered On: Mar 13, 2007

Do you know if there is a way to do this using SharePoint Designer?

Answer #3 Answered By: Tricia Mullins Answered On: Mar 13, 2007

I'm not aware of a way to do this with SPD. However, if you are a
programmer, you can create a Custom Field Type that could pull back
multiple columns from the related list.

Didn't find what you were looking for? Find more on doing "lookups" to return the value of more than one column Or get search suggestion and latest updates.