I use Drupal as a corporate CMS management platform. I use the event.module to (uh) list events, and then the book.module to create a rich detailed overview and navigational framework with specific details about the event (includes things like "overview", "registration info", "volunteer info", "required gear lists", "event location details", etc...).
I would like to dynamically include the contents of the overview page for each of the evnets, listed as a node within the book.module.
My question is this; is it possible to set the contents of the event.module listing to dynamically pull the content of a specified node (eg from the book.module)? I'm guessing that maybe if I use a PHP type setting for the event listing, and then do an SQL query to grab the contents of the appropriate node from the DB?
Does anyone have any other (maybe more elegant) ideas on how to do this? Or pointers on the SQL code I might need to execute to do this? TIA!
