Technology --< ProductTechnology >-- Product
and are importing into ProductTechnology?
If I understand correctly, you're importing into ProductTechnology, and mapping the technology name from the Excel file to a field that is supposed to actually hold a technology ID – regardless of what the popup reads (due to “Show only values from second field”), the field holds the value from the first field of the value list.
That means you need to either import such an ID, or use a separate field for import to drive a relationship by technology name to lookup the associated ID. Then find all freshly imported without a technology ID – here either the technology name is misspelt, or that technology doesn't have its own record yet.
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.
The actual problem seems to be as described above. Once that is corrected, and you're using a foreign key as a reference, then any such change in the parent will be reflected automatically in the related child/join records. That is piece and parcel of a related database system …
erolst Thank you for your response. It took me a minute to wrap my head around what you were saying, but now I get that even though my field is displaying the TechnologyName, it is actually holding the __pkTechnology unique ID.
Now, can you help me understand how I would create a field that uses the imported TechnologyName to lookup the correct corresponding __pkTechnology ID? (It won't be possible to have that ID as part of my import.)
Thanks for your help!
Add a text field like technologyName_import; create a new table occurrence of the Technology table,say, Technology_byName, and a new relationship where
ProductTechnology::technologyName_import = Technology_byName::technologyName
Then define an auto-enter option for ProductTechnology::__fkTechnology as
Thank you! You have been incredibly helpful!