Combining two fields in one combo box

[Haynesey]

Hi,
I am designing an inventory database and have separated PCs from their peripherals. Is their anway of combining the two fields values in one combo box?

Thanks in advance
Lee

 

[Rich]

If you mean just to display the two fields combined then yes it's [Field1]&[Field2] in the combo's underlying query