AnsweredAssumed Answered

Field in table needs to hold multiple values

Question asked by arobison1 on Jul 16, 2018
Latest reply on Jul 16, 2018 by philmodjunk

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.

Outcomes