CiviCRM Community Forums (archive)

OK, I can't work this one, looks like I need some code somewhere to have a Views relationship that I otherwise wouldn't have.

Here's what I'm trying to achieve.

1) I have uploaded all the local authorities in my country to civicrm and have downloaded all of their contact Ids.
2) I have generated a csv file of all postcodes in my country, matched to civicrm contact ids for each local authority.
3) I have created a node type called "Postcode" in Drupal, with a CiviCRM contact CCK field.
4) You guessed it, all the postcodes and civicrm contact id's have been uploaded to Drupal.
5) Now, I have a simple view in which I can type in a postcode and get back just 1 field, the CiviCRM contact URL, which the user can click on.

*BUT* I'd like something a bit more complex, you know, something that can display the details of local authority such as contact details, website etc....

Any takers? Thanks!