I have an application that I want to display a list of Part numbers in a listbox,

and for each of those part numbers, if they are serialized, I want to be able to display the serial numbers in another listbox.

My Access tables are as follows.

Table name PARTS: Key field [Part Number]

Table name SERIALS: Key field [Serial Number]

I got the P/N listbox to work fine without the serial numbers, but then when I join theSERIAL NUMBERtable to the PART table the data doesn't display correctly.

Not all parts are serialized.

When I cursor down through the Parts list, if serial numbers are available I want to display them only for that Part,

I am using an oledbDataAdapter and a dataset with the Select command as follows.

SELECT Parts.Location, Parts.Notes, Parts.[Part Description], Parts.[Part Number], Parts.QOH, Parts.Serialized, Serials.[Serial Number]
FROM (PartsLEFT OUTER JOIN
Serials ON Parts.[Part Number] = Serials.[Part Number])

the way the data is being displayed now is that all Parts aredisplayed in the parts Listbox, and all serial number are displayed in the serial number Listbox. If there are no Serial numbers for a Part then a blank line is displayed.

Any help would be appreciated,

please let me know if more info is required.

Regards

Tattoo