linking descriptions to a datacombo value

[Playmaker]

Hi, I have two datacombo boxes that are populated with number codes fields. One has 'location codes' and the other is 'occupation codes'. These fields come from my 'Claims' table in SQL 7. I have two small tables called 'LocationCodes' and 'OccupationCodes' that have the same codes as in the 'Claims' table and their respective descriptions. What I want to do is make it so that when the user clicks the datacombo box and selects one of the available number codes, the appropriate description for that code will display. Can somebody help?

[Forest Dragon]

You can use TextBox controls that will be bound to the tables that contain the descriptions for the codes. Then, whenever the user selects an item in the ComboBox, use the Find method to move to the appropriate records and show the values. I suppose the Code field in both of the tables is the primary key so the Find method will return only one result.