I am at the point in db design where i need to be able to ADD products as well as subtract them. I have accomplished all of this. Here is my question.
I have a Orders table and a OrderDetails table. The Orders table is for the whole Order and the OrderDetails table shows what products have been purchased for that order.
My subform for the Products chosen uses both the Orders and OrderDetails tables.
Blah,Blah,,, It is setup right now so that the user can Buy items, i.e. Subtract them from Inventory.
I now need to ADD items to Inventory.
I added another form to use to accomplish this since I dont know how to do it with the same form.
No room on main form for another subform.
Can I use a popup form and it still be linked to the order?
Is there a better approach?