I was wondering if it is possible for the dropdown list to be autopopulated with values from another field. For example:

View 1 "Authors":

Name, Books written

View 2 "Books": 

Title, Author(dropdown)

Now, I would like the Author(dropdown) in Books to automatically contain the list of records from the column Name (in Authors). Is this possible?