Hi,
I have a form where user can choose products and bills generated. The "Billing" table contains information of individual bill i.e Bill ID 101 contains 3 products. I want when user choose the items and click update , the information from Billing table go to inventory table (i.e billno, product id, qty etc), and suppose on later user added another product to Bill no 101 I want to add new product to Inventory table and if user just make editing in exiting items under Bill No 101 then prices/ qty got updated in Inventory table.
suggestion either query or vba?
I have a form where user can choose products and bills generated. The "Billing" table contains information of individual bill i.e Bill ID 101 contains 3 products. I want when user choose the items and click update , the information from Billing table go to inventory table (i.e billno, product id, qty etc), and suppose on later user added another product to Bill no 101 I want to add new product to Inventory table and if user just make editing in exiting items under Bill No 101 then prices/ qty got updated in Inventory table.
suggestion either query or vba?