Just having a liitle problem here.
I have identfied three entities, Bookings, Guests and Rooms for a reservation system for a hotel.
A guest can have many bookings.
A booking can have many guests.
A room can have many guests.
A guest can book many rooms.
A booking can have many rooms.
A rooms can have many bookings.
This would mean that all the entites would have a many-to-many relationship between each of them. Since you can't have many-to-many relationships in Access how would I correct this.