I'm having a problem. I have the following table relationships. Some events are weeklong and away and don't require attendance. Some events are local occur regularly and do require attendance. I've got portals working fairly well. What I want to do is get a report printed out for attendance at the regularly occurring events. An example: An event, mission trip, will have to persons attending. It's a one time, week long event. Another event, Lunch for Kids, recurs weekly with some different people attending each week. I'd like to get a report of who attends the Lunch for Kids, with weekly subtotals, names, etc... I cannot figure out how to do that using portals. There's a sample file at http://tinyurl.com/3bv97mb
Any help will be appreciated.