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?
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).
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?