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?
Thanks in advance for the assistance!