I have an inventory database I'm designing and I want to have a combo box whose options are generated by data already put into that column. If I link the sourcedata to that field of the table, I get the options, but I also get all the duplicates. I also cannot turn off the "Limit to List" function so that new information can be entered.

Little help?