I need some assistance with Microsoft Access. I$\text{'}$m attempting to create a subform that keeps track of the nominees of the Game Awards from the year $2014-2019$ that contains the fields Year, Category, Nominee, Company, Winner, and Voted. For the first $4$ fields I$\text{'}$m attempting to create a drop down box, but I$\text{'}$m having issue's with the Year section having duplicates, due to it being linked to the primary Key. I only want each year to be displayed once.