Hi Everyone,
My Case is about Auto Updating a Table that is not in the form I want to use.. Like Below:
First of all.. I have a table for Storage... (Inventory Application), which refers to Product ,Quantity ,Ex Date , Reference Inventory(FK) from Inventory Table Indicating which Inventory this storage is...
And I Have 2 Tables for Invoice, Invoice Header and the other is Invoice Lines,
Header Contains Inv No. , Supplier, Date of Invoice and Received Date,
Lines Contains Line Product ,Quantity ,Exp Date and Reference Inv No. (FK) Indicating that this line for what Invoice..
The Case Exactly is.. I've a Form for Invoice Header containing a Subform of Invoice Lines, (Connected to the Tables)
and what I'm trying to do is to Auto Update Storage table (which is not connected to form, but surely my Database has the Required Relationships)
and Auto Update Storage table with Lines, I Mean to add Records and also to Increase Quantity of Products if other Fields Match..
I'm not into Macros or VBA as well.. but can anyone provide me with a good solution?
And Thanks
Haitham Ebeido
Underlined : Tables
Bold : Columns