Mike
Sun Jun 15 14:02:27 CDT 2008
You can combine three SP lists (as tables) in Access 2007 too. It's just
a bit more difficult than two.
Mike Walsh
Ahmed Atia wrote:
> Thanks for reply.
> What I need to achieve is, I've 3 lists and I want to generate reports
> based on
> the three lists, so I want to join the three lists together, how can I
> do this?!
>
>
> On Jun 15, 12:55 pm, Mike Walsh <englantilai...@hotmail.com> wrote:
>> It depends what you want to achieve (and it's the same for both WSS and
>> MOSS - note though that this newsgroup is only for WSS questions)
>>
>> If you want to join two lists on a web page, you can use the web parts
>> of the lists on the page and then join them with web part connections
>> (for which they need to have a common field but it doesn't have to have
>> the same name)
>>
>> If you want to create a report combining two lists, you can create
>> tables for the lists in Access 2007 and use Access 2007 reporting tools
>> to create a report from both lists/tables.
>>
>> If you want to have a *field* in one list that has contents from another
>> list you can add a field of type Lookup.
>>
>> If you are looking for anything else than these three options, please
>> let us know exactly what:
>>
>> Mike Walsh
>> WSS FAQ
http://www.wssfaq.com/http://www.collutions.com
>> no private questions please
>>
>>
>>
>> Ahmed Atia wrote:
>>> Hi all,
>>> I am a SharePoint beginner, and I have a question,
>>> How can I join more than 2 lists in SharePoint, and I want
>>> this to work with WSS, is this available in WSS or MOSS to
>>> join more than 2 lists?!
>