I am working on a database that needs to keep track of which individuals have received the next book in the set of books and when they received it. So for client "A", it should show they have received the first couple books like this:
Book 1 - 7/12/18
Book 2 - 7/16/18
Book 3 - Not yet received
and so on...
Any ideas on how to do this neatly? I realize this may call for other related tables, I just am not sure how to go about doing it.