L
Leslie
In my DB we track all non-conforming material (stock items from vendors) and
RGA's (Return Goods-field returns from our Customers/Distributors). We use
Access 2003.
My problem is that I have a form that is ran using a query and then a
command button to print the report to be shipped with the part back to the
vendor that we use to create MRV's (Material Return to Vendors).
When I create the first MRV for a particular vendor (ABC) it gives me the
new number (113-F) and shows the 3 parts to be returned to that vendor on the
sub-form. That is connected to the MRV primary form using the vendor number.
The MRV with all vendor information is the primary form and the sub-form
(child) is the part information. The report is created in the same manner
using a primary form (all vendor information) and a sub-form (all part
information).
Now when I go to do a second MRV to the same vendor (ABC) and I have 4 parts
to return this time, I get the 4 parts plus the original 3 parts and even
though I have requested a new number and the form gives me a new number when
the report prints it uses the original MRV number. I am at a loss as to how
to get this to work. It doesn't seem to hold the fact that the first ones
were processed on the MRV 113-F and a new number and new form/report with
only the 4 parts needs to be generated.
The MRV number is generated as an auto number in the database and a second
field adds the -F or -S for field or stock depending on the parts being
returned. And I have not concantenated the 2 fields together.
I thought about the inovice but that doesn't seem to be quite what we are
trying to do either, any help would be appreciated.
Thanks,
RGA's (Return Goods-field returns from our Customers/Distributors). We use
Access 2003.
My problem is that I have a form that is ran using a query and then a
command button to print the report to be shipped with the part back to the
vendor that we use to create MRV's (Material Return to Vendors).
When I create the first MRV for a particular vendor (ABC) it gives me the
new number (113-F) and shows the 3 parts to be returned to that vendor on the
sub-form. That is connected to the MRV primary form using the vendor number.
The MRV with all vendor information is the primary form and the sub-form
(child) is the part information. The report is created in the same manner
using a primary form (all vendor information) and a sub-form (all part
information).
Now when I go to do a second MRV to the same vendor (ABC) and I have 4 parts
to return this time, I get the 4 parts plus the original 3 parts and even
though I have requested a new number and the form gives me a new number when
the report prints it uses the original MRV number. I am at a loss as to how
to get this to work. It doesn't seem to hold the fact that the first ones
were processed on the MRV 113-F and a new number and new form/report with
only the 4 parts needs to be generated.
The MRV number is generated as an auto number in the database and a second
field adds the -F or -S for field or stock depending on the parts being
returned. And I have not concantenated the 2 fields together.
I thought about the inovice but that doesn't seem to be quite what we are
trying to do either, any help would be appreciated.
Thanks,