Question Compare / Lookup Multiple Values (1 Viewer)

I am currently working with a database which performs a crossover from a competitor part number to our part number. The current process is:

1)Chooses the competitor name from a drop down

2)Chooses the competitor part number from a secondary drop down

3)Our part number shows up in a protected text box which matches the specific part.

My question is... My supervisor wants me to have the ability to have a form field where I can type out a few part numbers, and then I click a button and it returns the crossover parts according to the competitor parts listed in the form. Is this possible in Access 2007? What are your general thoughts about this? I appreciate any help and opinions.

Thanks,

Bradley

I'm not sure I completely understand your supervisors request but I believe the answer is yes. Maybe with a little more explaination I could give a better answer.