1 of 1 people found this helpful
Looking at the pics from your other post: In your relationship graph, you're matching NAME with CODE. You need to match NAME with NAME. When the names match, it's the CODE that will be looked up. Make sense?
That said, this seems completely backward to me. Typically you use codes (aka key fields) to look up names, since names sometimes change but a code or key would not.
Thank you Fitch. In retrospect it makes a heck of a lot more sense than what I was doing. The reason it is bas-akwards is that we formulate using the actual raw material names when we put the formula together. The formula is then entered into a main-framed dinosaur at corporate headquarters which only accepts what we refer to as the internal IBM codes. So in order to give the production folks a formula that they can enter to cut batch tickets on the dinosaur without the formulators having to look up the extra codes, we have the codes pulled up when the raw material name is typed in. Makes no sense to me either but then I don’t own the company or the dinosaur. As well, I was not the developer of the initial solution and when he left it fell to me to maintain and expand the installation. I am in the process of learning the system and I appreciate all of the patience that has been shown to me by members of the community and just hope that it continues until such time as I can become a contributor as well.
image001.jpg 484 bytes