help / question with invoice form already set up.....

[Brook]

good day all...

I have a frminvoices that I use for both Consignment and Sold Invoices....
What I am trying to accomplish is this... As of right now the frminvoices
contains a subform based on my orders/inventory that I have on hand. when I
create an invoice either Consignment or Sold the orders are added and there
are no duplicates allowed so that same inventory item cannot be added to
multiple invoices (the reason being is that I have unique inventory items,
all have unique properties).

What I am trying to accomplish is this... and am open for suggestions
comments...

when I have a consignment invoice from a company and the one or more of
the items on the invoice have sold, I have to create a sold invoice in which
I need to be able to "transfer/move" the item from consignment to sold
status. is there a way that I can have the form set up so that it ask me if
the item is sold and the user clicks yes, then the item can be added to the
sold invoice and a field within the tblorders is updated with a Sold status
and date?

I hope all this is clear... please let me know if you have any questions...

thanks...

Brook