I have a table of technologies. Each technology has a unique ID that is a auto-generated serial number (__pkTechnology) and a name (TechnologyName).
I am using those pieces of data to populate a value list, where __pkTechnology is the first field and TechnologyName is the second field. I am only showing values from the second field.
This value list is used in a pop-up menu on a second table, where I am indicating technologies used for a given product. Each product can use multiple technologies. Each one is stored as a separate record (with a bit of additional data).
Most of my data is imported from Excel files in big chunks of a couple thousand records at a time. I can have it validate that each TechnologyName imported is on the value list. After import, I notice that when I click on the pop-up menu for an imported record, it does not jump to the name on the list that is displaying in the field. it just goes to the top of the list (e.g. the field reads "Vibram" but when I click on the field it goes too "500down", which is the first item on the list). I can scroll through and find the correct name and select it. Then it will jump to that name in the list the next time I click on it.
I want to be able to change the TechnologyName on the first table and have it ripple through all of the entries on the second table, without having to go through thousands of records manually and select names from the value list. Right now, the only TechnologyNames that automatically update are the ones which I have manually selected from the pop-up menu.
Any thoughts on how to correct this?