Add Grouping Level - Event Enrollment in Microsoft Access


	Back to Event Enrollment Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Add Grouping Level

Scott Axton

3 years ago

Hey guys

My turn to come to the well of knowledge.  I'm coming up with a big zero on this one.
I'm looking mainly for ideas on adding functionality.

I need to add to the enrollment a "grouping" or "pairing" level but don't see how at the moment.

Some examples -

Seating at tables:  Table one has 10 seats.
Number of rooms:  x people in a room
Transportation: The vans hold 6. 48 seats on a school bus.
Teams in a golf tournament:  Single, Twosome, and Foursome

Each event could have differing grouping levels. One might be no grouping. The next might be as above.

I would love some ideas. How would you tackle this?

Thanks!

Scott

Kevin Robertson @Reply

3 years ago

Not really sure how you want your report to look. Got a mock-up to show us?

I created a report in the stock database but not really sure if it's what you're looking for.
To create it I set up a grouping table and a junction table for events, customers and groups.
A couple of queries to bring everything together and an aggregate query to get rid of duplicates.
Then built my report. Does this sound like what you are looking for (the report is below).

	Kevin Robertson @Reply 3 years ago

	Scott Axton OP @Reply 3 years ago
Thanks Kevin but I hadn't even thought about reporting yet. I was / am still trying to think through structure changes to the tables to accommodate putting people into the groups. Then tie those to the event. I have the concept down of many to many but is this m-t-m with the person or the event?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Event Enrollment.

Next Unseen

New Feature: Comment Live View