With great help from the forum, I accomplished my goal . Unfortunately, the
boss reviewed it and now he wants something different.. Figures.. Make
something easier for him.. and he wants even more features... sigh...

Anyway, I have a parts list that I need to make a purchase orders for. The
data is entered in by one department based on what their design requires.
Another department creates a purchase order for it.

Consists of an ID #, qty, description, part number, material, alternative
material number, and miscellaneous.

The majority of the time the material indicates which vendor the part will
be ordered from.. this is easy to do (now).. filter out unique material..
use drop down and using advanced filter, have it appear on a purchase order.
However, now the indication is.. yes, that is the way they want it MOST of
the time.. However. sometimes they will order other materials from the same
vendor as well. So he wants to be able to pick and choose... and wants it
done as easy as possible (for him, as little fuss as possible)... The only
truly unique information appearing in this list is the ID # and part number.
So, basically I need to choose a material to be ordered, show all materials
that are the same, and from that be able to choose which ones based on the
results of that list.. and add it to my purchase order.. Then choose a
different material, pick and chose which parts from those materials.. and
also add it to that same purchase order.

I am not quite sure how to go about this...

Any ideas, direction....

Thanks in advance (once again)