Create a relationship between two records?

Create a relationship between two records?

Hi pals,

I'm building a marketing content inventory application to keep track of all the content my marketing department produces. (Brochures, white papers, case studies, etc.)

One way a content department makes itself more efficient is by deriving one piece of content from another. For example, if I write a 3-page white paper, I can derive a blog entry and a newsletter article from the white paper with very little effort.

Each one of those items are a "content item" on their own. They're all entered into the system using the same form, because they all have the same attributes (content type, audience, date published, etc.) But at the same time, I want to know which is the parent content and what child content it has spawned.

So here's my question: how can I establish a relationship between the content items? Here's what I'm hoping to achieve:

Q: Is this content derived from other content?
_Yes    _No

Q: If yes, which piece of content was it derived from?
<dropdown list with all the other content items in the system>

Thanks for your help,

dave