Combo Box Problem.... i need a "light"....

SELECT DISTINCT PeripheralName FROM SystemTable

Here's the long answer. There should be a table that already has a distinct list of peripherals. (You should create one, if it doesn't already exist.) So, the real answer is to use this table as the source of your combo box. Using your example above, you'd have a Peripheral table with three records, one each for "Monitor", "Printer", and "Scanner". No need to do a DISTINCT and you have a better designed database.

Hope this helps.

- Mitchell S. Honnert

MitchellS.Honnert at 2007-9-8 >