I was hoping somebody could kindly shed some light on a relatively basic function for I am trying to execute in Delphi for a project I am completing for work. I am very new to the world of Delphi so any assistance would be greatly appreciated.
I have connected a MS Access Database to some DBLookupComboBoxes. A one to many relationship exists whereby a user selects a particular material from a dropdown menu, but for each material, there may be more than one colour that the user can select, all of which price may differ.
Currently, if a user selects a particular material, all the colours within the database display, irrespective of material chosen. In addition, depending on the material that is selected, all the colours are highlighted by the pointer for when the user attempts to chose a colour.
I eagerly anticipate any reponse from the professionals!!