Select from two fields in Combo?

Hi there, does anyone know how to let the user select a record from a database - giving them a combination of two fields to choose from and not just the one suplied by the combo box? Thanks