Hi all, I need some help again. I have a database with an OrderStatus table that is used to log material coming in from a vendor. It works fine if all is complete, however, if there is a backorder I want it to create another line for that item showing the balance due in. At present there is a checkbox that indicates Partial. If the backorder comes in on 2 other shipments there is no way to track it properly. How can I make it create more lines for that product? Specifics please.
(I have attached a sample screenshot of what I am working with.)
thanks in advance for any and all help.