First time building a database in Access. I've been searching, but I did not find something to solve my question, so I finally decided to ask.
It may be a really stupid question but what is the best way to format something like the following:
One service is provided to two different recipients (table 1). These recipients are located in a recipient registry (table 2).
What is the best way to join both tables? Shall I create 2 tables:
SecondaryRecipient? Or a join table with the combination of recipients?