Miguel,
Thanks, but I'm trying to link the "list" of contracts to a report that shows
obsolete/slow moving items. The idea is to alert the Product Managers that
these parts have a contract commitment which may need to be terminated or
modified.
The obsolete report looks like this:
PartNo Part desc Contract or Pricing Agreement Forecast Planned PO SO
0-0602121-5 AMPACT TAP ASSY Y
0-0602300-0 AMPACT TAP ASSY YELLOW 602300 Y
1-0275187-8 COPPER AMPACT TAP ASSY Y

Ashley



Miguel Zapico wrote:
You can use the autofilter option (Data - Filter - Autofilter). It will
show a drop down on the part number, and selecting one element will hide all
the lines but the ones that have that number on them.

Hope this helps,
Miguel.

Hi, all.
I'm trying to figure out how to display all the contract numbers that relate
[quoted text clipped - 9 lines]
0-0069338-1 VUYTS2004
0-0069338-1 WWYMISC-WP-AMP