TBL_Items (ItemsID, Item) and TBL_Order (OrderID, OrderItem, DeliveredItem).
At TBL_Items it is possible to find an items that has equal funtion to other. (Item1=Item23)
A customer asks for Item1 and with a ComboBox I select Item1 and fill OrderItem.
At the moment to deliver there are not Item1 and we replace it for Item23, also we update field DeliveredItem from TBL_Items with Item23.
I would like to have a form filtered by customer with sub-forms with all the orders for that customer, I would like to perform some changes (with a ComboBox) at an Order within the subform.
Thanks and regards
Access 2007- XP Pro
February 11, 2010 2:14 AM
February 13, 2010 5:13 AM