Hello

First can i say that this forum is great and has helped me a lot.

My problem:

I work in purchasing and one of my tasks is to find out which parts i need each week.

The current way of doing this is to get the parent number (from a spreadsheet), and look individually from the system to get the parts inside and find the supplier. Its the latter which I need to sort out (Finding the supplier).

At my old employer we read this information from the system but here is a lot more strict and wont allow us access.

Is there a way to enter the part number into a column and it automatically pick up the supplier? Would i need a master list of all parts and suppliers for this?

any help would be great (or if you need me to explain better)