I'm wondering whether to install calendar script, but one important aspect would be the ability to select a particular value for one field and it then pick up standard data from other fields. eg, if it was address details for an event, I'd like to be able to select a venue name and then automatically pull in address details, map link, perhaps an image file etc. The reason for this, rather than lumping all the information together into one field is to allow searching on any of the fields associated with an event.
In database terms, I'm looking for a relational database type facility, rather than a flat structure.
Is this possible?