I have a reading log base that I’ve adapted from the ‘Book catalog’ template. I have 4 tables: Titles, Authors, Narrators, Pseudonyms. I couple of things I’m not sure how to do are:
Link pseudonyms to authors/narrators without having multiple records (see Cornell Collins/Matthew Lloyd Davies in the screenshot)
Log re-reads by date (like you can in Goodreads) without creating additional records for a title. At the moment I have the following fields: Date started; Date finished. I don’t want to overwrite these fields every time I re-read as one of my aims with the log is to record how many books I’ve read in a year (and re-reads count).
Many thanks in advance for your help.