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.)