May 11, 200718 yr Hiya... I'm working on an Event's database, that incorporates attendees info, events and the people who organize events. Event teams tend to be fairly static with people repeating roles regularly. As they are an Event team member, they also show up in the attendees table, as they've attended an Event. I'm wanting to display events that individual attendees have been involved with, and the specific role they played... ie, Jane Smith 'ORGANISED' 'EventID' 001 & 'ASSISTED' 'EventID' 002, on the Attendees / Contacts layout. So far I can display through a portal Event Team data, but I want data that specifically and only relates to the individual. I have 2 tables :: Events, Attendees, with two join tables :: Registrations (links Events to Attendees) and EventTeams (links teams to events!). Can this be done through a portal..? The purpose of this is to display the training history of attendees. Thanks :confused:
Create an account or sign in to comment