So basically what I want to achieve is the following:
I have two content types, lets say a "story" and an "advertisement". I have appended two CCK fields (currently just text, but eventually locations) to my stories, while another CCK field (also currently just text, but eventually a location) is appended to my advertisement.
Now I want to display two blocks below my story nodes. The first block should display advertisements where the advertisment's CCK field value matches that of the first CCK value appended to the story, and another block showing ads where the advertisement's CCK field value matches that of the second CCK value appended to the story.
From my background reading I understand that including an argument with PHP code that will load the current node's CCK values into parameters and then filtering from there would be the way to go, but I'm not quite sure how to approach this.
Eventually I would like to improve this system to the point where the ads are filtered according to proximity (e.g. the location associated with the advertisement is within a 10 mile radius of the story's first associated location, and is therefore displayed), but for the time being simple matching of the CCK text fields wil suffice.