I have created an Access 2016 database and need some advice on Primary Keys and a Combo Box.

I think I set my database up wrong by using a Combo Box in a table. I did that so I could select a Retailer name while entering records. Trying to get the Retailer name and not the RetailerID on Forms and Reports, it hasn't been that easy. So, I have decided to start a new database, hopefully, the right way this time. I have imported into a...