Use One Content type's field as a reference in another content type's view?

Question

I have following requirements :

Add and List of Book Add and List of Quiz related to book.

I have created content type for Book with field name : book_id,book_name,price etc..,here book_id will be unique in every time.

Also created content type for quiz with field name : quiz_name,my_book_id etc..

Now in view of quiz i have to show field quiz_name with book_name. How can it will be possible to map this field?

I refered too much like entity reference, node reference module etc but didnt get any solution.

Answer 1

My solutions is

1. In your Quiz content type remove book_id field , add another field with (each name you want here I named it my_book_id ) select type node reference for it.

then in views, create a views of content type quiz, create a relation on my_book_id then you can add book title .

2. Another way is using php views field create a views with content type quiz, select quiz desire field, then add my_book_id field ,exlude it from dispaly then create php field , in value use something like this

<? 
 $node=node_load($data->mybookid); // this is not precise way, you should put nid in node_load(nid);
 print $node->title;
?>