Accessing Data using the DataCombo box

[TheOneRing]

Gedday,
I have a datacombo box that is filled with customer names from a dataenvironment command. What I want to know is there any eay way to retrieve the relevant data from this control without have to search the whole table to find the match.

i.e. I select say John Smith in the list. Now I want to get his address and phone number etc. At the moment I use a while do....loop to search through the whole table to find the match and then extract the data I want. Is there any easier way.

Help Would be much appreciated.

thanks