How to establish a relation among two content types in drupal 7

Question

Consider there are two CCK's Products and Reviews(reviews for a product) how to relate them?

There can be any number of reviews for a product. Hence i may want to retrieve all the reviews that belongs to a particular product OR Create a Review OR Delete OR Update.

Is there any module in drupal to accomplish this?

UPDATE

I tried this using Entity Reference module

First I created a REVIEWS CCK with the following fields Name, Email, Review, Rating, Product(This is the Entity Reference, So that it helps to determine the Product to which the review is belonged to).

Products CCk

Product Name, Product Description, Product Cost

Consider there are 3 products A, B, C and i want to review for Product A. I must add all the fields such as Name, email etc and have to select a Product from Drop down

This is Better. But the interesting point is How can i Retrieve all the reviews that belongs to Product A ?

If i create a VIEW to list all the Products i cannot get It's reviews.
Similarly if i create a view to list all Reviews i will get only product name but not its details.

Do any one have any Idea how to solve this?

Many Thanks.

Answer 1

It looks like you need Entity reference module:

Provides a field type that can reference arbitrary entities

Just add product reference to review content type.

Answer 2

Entity reference is preferred choice as it's in D8 core and uses entity's architecture. For some reason Entity Reference module has less functionality then References module. I needed to filter referenced users by role and this can only be done with References.

Answer 3

In view add a relationship of product entity and select as required, after this add fields of product cck and select use the relation ship dropdown in field settings and in this way you should get all the needed data.