How to relate a field to another field in content type like a foregn key? Can anyone guide my to the best method or module to connect 2 fields together?
I want to create a field called (Author) in a content type book, which will refer to a field called (name) in a content type author.

So a book author, will refer to field name of an actual existing author.

It's like creating a foreign key from the a book field to the author author field.

But the modules that I found (like node relation, relation and entity reference) only do a node reference, which is not what I want.

Not sure if I did use the modules correctly. But am I missing something here?

I am kind of new to Drupal as well as the web development era.

Any help?
Instead of using relationships use field collection module. In this module you may create a collection of fields that they all point to an entity. 

As an example you can create author collection and in this collection insert first name field,last name field,gender field or any other information you need. 

You can add this collection as a field to the book content type.