I am creating a base that has 4 different tables. ‘Books,’ ‘Authors,’ ‘Themes,’ and ‘Quotes.’ I want all of these tables to be linked. My current issue is with the ‘Quote’ and ‘Theme’ table. When I enter a new quote, I enter the book, author, and theme. When I go to the ‘theme’ table, it shows the quote but is not linking with the ‘Book’ and ‘Author’ tables, meaning that I have to go in and manually add the book and author in the ‘Theme’ table. Why does this information not transfer from the initial entry on the quote table?