Good day, 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.

its like creating a foreign key from the a book field to the author author field.

but all what i get in the modules i found (eg. node relation, relation, entity reference only do a node reference so far. which is not what i wanted.

not sure whether 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, i used to do basic Java SE programming.

Please guide me. Thank you for your time.

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?