I'm a volunteer Drupal admin/developer for my church. We're running a fairly active Drupal site at http://bethlehem-church.org.

The last piece of our puzzle is a module or CCK/Views recipe that will help us manage the church facilities--i.e. make room reservations for the various groups that meet on campus, and tie those room reservations in with the Drupal event calendar. We want to allow users to create event nodes and assign them to a particular room/rooms for a specified date/time period without allowing duplicate booking.

Has anyone used Drupal in this way: to manage facilities? Or does anybody have any top-of-the-head genius ideas as to how this might work?