1
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 new database the Inventory table and the Retailer table.
With a large Inventory table doing this manually is not an option, it needs some VBA code to transfer the results of the Combo Box to a new Field within the same table. I created a new Field called Supplier. The Table has a Primary Key and is assigned to each record and each record has a Retailer who supplied the Item.
Needed is a way to transfer the Retailer name from the Combo Box to the new text field in the table that is associated with that record. This way I can eliminate the Combo Box and all my headaches and build the database the right way.
Transfer:
Retailer name from Combo Box to new Supplier text Field for each record.
I have learned a lot by watching videos and reading, thus screen name RedEyes.
Thank you
