Jump to content
Sign in to follow this  
Lizzy

specific info in portals

Recommended Posts

Hello to All!

I posted this in portals, but in retrospect, its a relationship thing...

Any suggestions would be gratefully recieved...

With thanks

-------------

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

Share this post


Link to post
Share on other sites

I don't get why you operate with two join tables, when it seems like what you're after has a lot in common with this:

http://www.fmforums.com/forum/showpost.php?post/250326/

...allthough it has been outfitted with extra features to prevent double bookings, neither has the reporting you're after been touched yet, but as a rule should the reporting be done in the join table, to make things go as easy as posible.

--sd

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    enstorms 
×

Important Information

By using this site, you agree to our Terms of Use.