MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Linked Sources (Data Sources) In Sharepoint Designer 2007

  Asked By: Stevie    Date: Aug 03    Category: MOSS    Views: 2457

I am trying to create a form / page that shows which corresponding
events are to be attended by individuals.

I have 3 tables / lists:

Events [EventID],
[Event Name]

Attendees [AttendeeID], [First
Name], [Last Name], [Full Name]

AttendeeEventLinkage [AttendeeEventID], [Full Name],
[Event Name]

(In the AttendeeEventLinkage list, [Full Name] and [Event Name] are look
up columns).

The goal is to show which events a given person (attendee) is attending.
Is there a straightforward way to do this? (If I were to link on a
"Full Name" column, then it will mix up people with the same name...).
I seem unable to link the data as I would easily in Microsoft Access.
Also, Sharepoint seems to treat Lookup Columns as memo fields; I cannot
see how to perform "joins" against the numeric value of the lookup field
(i.e., Full Name, Event Name). It would see this would be key to
solving the problem.

(As it is now, SharePoint appears to link AttendeeID with EventID, which
makes no sense whatsoever.)



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Linked Sources (Data Sources) In Sharepoint Designer 2007 Or get search suggestion and latest updates.