Specific info in portal records

[Lizzy]

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: