I'm currently creating an ecommerce site using Drupal and the Ubercart module, for each product I need to have the option to display an article (blog/story) that relates to that specific product. I also need the article pages to display related products. I initially intended to do this via taxonomy, i.e. using tags to link the products and articles and creating blocks with the necessary filters but I thought that this would become messy as the product catalog grows. I know that i could just create a custom field and write my own sql queries to grab the relevant content and display it but i was wondering if there's any built in functionality (or modules) that would enable me to link an an article to a product during the product creation process. Like a drop down menu on the add product screen where i could select and relevant article.
I've looked over many module specs and forum posts but can't seem to find a solution to this kind of problem.
Any pointers would be very much appreciated.
Use the References module for referencing to other nodes or users.
Install this module, then add module type of this = Reference.
Notes: