Firstly Greeting to all of you.
im new in using Access, i have some question on updating table when i using subform
Table i have are
Inventory
Product
Categories
SO
SO Items
1. main form(SO Table) consist of the following
StockOrder ID
StockOrder Date
Customer
Jobsite
Date Submitted
Submitted By
Submitted Checkbox
Date Packed
Packed By
Packed Checkbox
Date Collected
Collected By
Collected Checkbox
Status
2. Subform(SO Item) Consist of the following (DateSheet)
StockOrder ID
Supplier Code
Stock Code
Product Name
Quantity
Status
what i would like to do is
step 1. i update my Subform by adding product and quantity which customer order. Example
Product Name Quantity
Chicken soup 6
Chicken Creamy Soup 10
step 2. i tick the Submitted checkbox in the main form
step 3. i want it to add the quantity to the inventory table Allocated field
step 4. after i pack and tick the Packed checkbox in the main form
step 5. it will remove the quantity from allocated field and add it to Shipped(Collected) Field
FYI i use shortform for StockOrder
SO = StockOrder
and also is there any automated ways to change the status field value in both
main form table, example SO Created, Packed, Completed
Subform table, allocated, SO Created, Shipped(Collected)
and also is it possible to create a report after SO is Created
Report with the Customer Order Detail
im new in using Access, i have some question on updating table when i using subform
Table i have are
Inventory
Product
Categories
SO
SO Items
1. main form(SO Table) consist of the following
StockOrder ID
StockOrder Date
Customer
Jobsite
Date Submitted
Submitted By
Submitted Checkbox
Date Packed
Packed By
Packed Checkbox
Date Collected
Collected By
Collected Checkbox
Status
2. Subform(SO Item) Consist of the following (DateSheet)
StockOrder ID
Supplier Code
Stock Code
Product Name
Quantity
Status
what i would like to do is
step 1. i update my Subform by adding product and quantity which customer order. Example
Product Name Quantity
Chicken soup 6
Chicken Creamy Soup 10
step 2. i tick the Submitted checkbox in the main form
step 3. i want it to add the quantity to the inventory table Allocated field
step 4. after i pack and tick the Packed checkbox in the main form
step 5. it will remove the quantity from allocated field and add it to Shipped(Collected) Field
FYI i use shortform for StockOrder
SO = StockOrder
and also is there any automated ways to change the status field value in both
main form table, example SO Created, Packed, Completed
Subform table, allocated, SO Created, Shipped(Collected)
and also is it possible to create a report after SO is Created
Report with the Customer Order Detail
