I am importing Excel data into Access. I would like to use combo boxes for a couple of fields to enter new data. I would like to clarify a couple of points before taking place.
1. In the database from Excel data, a lot of repeat value in the fields. If I use the combo box to enter the new data, what is the impact of the old data in the database already?
2. Does the master table contain the actual data using the combo boxes or just reference to other child tables?
3. When I move the master table to other database in the future, I have to move all child tables together, otherwise the database will not work correctly, not only the data entry using combo boxes.
Looking forward to your guidance on above. Thanks!