Hi All,
After a bit of help with this if anyone could...
I have two lists on my WSS site.
1 - Scheduled Events
2 - Consultant Assignments.
In the scheduled event list, each event has an ID code and the event title
In the consultant assignment list it refers to the ID code of the event but
does not store the event title
I want the data view to list the consultant assignments, and display the
event title from the scheduled event list eg.
Event Code Event Title Consultant Name
Date of Event
(from assignments) (from scheduled (from assignments) (from
scheduled
events)
events)
I know I can use a web part connection, but this means I have to click the
list.
What I want is something like the query builder in microsoft access, simply
drag and drop the fields from the 2 lists, and create a join on the event
UID. Is this possible?
Any help/advice greatly appreciated.
Cheers
Chris