I have a query which displays records linked to companies based on the ID:
<tbody>
ID
Name
Date
Current
ABC123
John Smith
01/01/19
Yes
ABC123
James Jackson
22/12/18
No
LMN321
Sam Franklin
12/10/18
No
LMN321
Danny Hudson
25/12/18
No
</tbody>
Is it possible to make the records show 1...