Searching access DB for multiple entries?

[CTBK]

I have an Access DB that contains a list of parts with the same identifier but they have different vendors associated with the same identifier. 

Ex:  CAP00001(identifier) has vendor A

       CAP00001                 has vendor B too.  The same Part number can have multiple vendors.  Any ideas on how I can search the DB for all the instances and return the vendors that are associated with this part.  Basically I can execute a search command and get the first entry but how do I search for the next available entry if there is one and present the information to the user?  Basically they enter the PN to query and I list an array or list of all the instances it found in the DB with the associated vendor.

LV 8.2.1

[Dennis_Knutson]

I have no idea what kind of 'search' command you are running but to query the database you would use the SQL command: SELECT vendor FROM table WHERE identifier = 'CAP00001'. This query will return all vendors with that id.

[CTBK]

I found out I was using the correct search function but I was not indexing the array properly.  Now everything is working fine.  Thanks for the help.