Re: Clearing table from duplicates on related table
use a find duplicates query to find the duplicates and delete one or more of them.
Struggling to understand what you are doing since the related link in the other table will be orphaned - so those need to be removed first
with regards your second question - it depends on the purpose but certainly I would expect to see a unique index because you wouldn't want duplicates. Whether you also have a primary key is another question
A little thanks goes a long way. If you have found this post useful, please tick the thanks button