I have a list which contains information about pieces of equipment. I also have a document library which contains things like certificates, receipts etc which relate to the equipment. In the list I have added a lookup column so I can link the two based on the equipment's unique identifying number. However in the lookup column, each unique identifying number appears once for every document.
Is there a way of linking one list item with multiple documents? Can I remove the duplicates from the lookup column?
I hope this makes sense, I can't think of how to explain this very well.