Reading base: link pseudonyms to authors and log re-reads

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:

  1. Link pseudonyms to authors/narrators without having multiple records (see Cornell Collins/Matthew Lloyd Davies in the screenshot)

  2. 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.
Capture

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.