I have an Access Database Table for Sales which lists multiple records and the Salesperson associated. Example below:
<tbody>
Batch
Salesperson Name
Date Allocated
1234
Alan Smith
01/02/2019
1234
Ryan Fisher
25/02/2019
1234
Danny Franklin
22/12/2018
0987
Ryan Fisher
14/02/2019
3453...