Report reusing items previously returned to our Vendor

[Leslie]

An MRV report (Material returned to Vendor) in my db we use to process parts
to return to our vendors, FYI: We are a manufacuturing / assembly company.

What is happening is that if I send MRV 116-F to Vendor ABC with 3 items on
the MRV, and then several days later when I have an 3 parts to return to
Vendor ABC
while I can create a new vendor MRV numbered 131-F it will show the 3 new
parts to return along with the 3 parts that I have already returned to Vendor
ABC. How can I go about preventing an item from showing up on the subsequent
MRV from once I have created an MRV with that part on it?

I have the MRV form created using a primary form (parent) for the vendor /
shipping / numbering etc, of the MRV and a sub-form (child) for the part
information for that Vendor showing info pertaining to the part like RGA No /
reason for return / date of failure / vendor number, etc. the RGA number is
the number that our Distributors use to return the part to us. the primary
form and sub form are linked using the vendor number.

Also I need to have the ability to recall the MRV once it is returned to the
vendor to process the credits / fees / etc. that may be associated with this
MRV and to complete the MRV once everything is taken care of , generation of
the MRV is only the first step.

I am using ACCESS 2003, any assistance would be helpful.