DataCombo

I have a customer form with a datacombo box on for occupation type. The occupation types are held within a lookup table containing lookupcode, description, attributeName. Within the customer table I hold the lookup code in a field called occupation which is linked to lookup table where attribute name = occupation.
When I show the customer form I use a recordset to populate the customer fields, how do I populate the datacombo properties within my code so when the user clicks on the box it shows all the relevant choices from the lookup table ?
I have done this before using the dataenvironment and setting the properties of the datacombo at design time but I don't want to set the properties at design time with this.

Any ideas would be much appreciated

Thanks

John

your saying if someone clicks on "computers" you want another combo to show "computer/hardware", "Computer/Software" ect....??

Ok....it's basically visual, what about the rest?

What I mean is if the current customer record shows 'developer' in the datacombo box, if I wanted to change this when I clicked on the dropdownarrow a list of all occupation types would be shown allowing a different occupation to be selected.

Hope this is clearer.

Thanks