display the corresponding values from the database for a certain value
I have a database with 5 fields.
First is the material list which I would want to display in a combo box and I am able to do so.
I am creating four text edit boxes where I would want to display the properties of the materials like density, conductivity etc.
The problem now is how can I get the corresponding properties to change in the text editbox as and when I change the material from the combo box.
Eg: Lets say I have copper, gold, aluminium. When I select copper, I would want the values 1, 2, 3, 4 displayed in the 4 different edit boxes. When I change the selection to gold, I would want the values to change to 5,6,7,8 automatically. All these values are stored in the datamaster. I know a workaround wherin I can set the values on change (of the material). Is there any simple way to go about it?