Main Table:" Event Detail" with primary key Event ID
Related Table: "Reservations" with primary key ReservationID
One Event has many Reservations.
I have a subform "Reservations Subform" that allows the user to input data into the underlying "Reservations" table. The fields are:
ReservationID (primary key)
The other info I need to store is the room(s) specific to a reservation, and ultimately, the total cost associated with their use. To make selection as simple as possible, I would ideally have a group of checkboxes displaying all available rooms, with the user being able to select whichever combination of rooms applies. For example:
Reservation ID: 1
Event Date: 5/5/06
Rooms: XLane XLyonsXLodato _Barnes _McDowell _Cranston
Total Usage Fees: $300 ($100 + $100 + $100 for each room)
Event Date: 5/6/06
Rooms: _Lane _Lyons_Lodato XBarnes XMcDowell _Cranston
Total Usage Fees: $200 ($100 + $100 for each room)
How do I best accomplish this? I'm assuming for the sake of data integrity that the "Rooms" data should be held in a junction table cataloging each reservation's multiple room selections, but can I create an option group of checkboxes (or use a listbox, even) to do so?
My primary concerns are 1) ease of selection - a subform on the subform allowing the user the create multiple "room" records using a combobox requires a lot of space, as I need all records to be visible and 2) I would eventually like to create a report that graphically displays reservations in a calendar format, so I need to respect design parameters so I'm ultimately able to accomplish this without an unbelievable amount of code (I realize it will take a lot as is!).