anandan.cr@gmail.com
Member
- Local time
- Today, 14:21
- Joined
- Oct 7, 2016
- Messages
- 43
I Have multiple Queries in Trans Form, but will ask one by one in each threads
I Have a three tables : Item_Mast, Flt_Master and Trns and all are linked as shown in Snapshot attached.
In Trans Form : All Three TABLES Data will be requiring in Trans form.
Here Combo Box: Item_Name will display and All the item from item_Mast table where MenuCategory='Food' and this item will save in trns table.
From item_Mast table where MenuCategory='SPML' and all the item_Name will save in Trans table along with Qty entered where Qty >0 in trns Table
Query : How to Create Sub Form/ Grid Format containing item_Mast!Item_Name where MenuCategory='SPML' , and Qty
should be saved as shown in Snapshot of Trans Table. ( Using VBA code)
Attached : (1) Snapshot (Showing Relationship Diagram Form: Item Master , Form : Trns, , Table: Trns)
(2) Unable to attach Ms Access database File, kindly allow the Access File to attach.
I Have a three tables : Item_Mast, Flt_Master and Trns and all are linked as shown in Snapshot attached.
In Trans Form : All Three TABLES Data will be requiring in Trans form.
Here Combo Box: Item_Name will display and All the item from item_Mast table where MenuCategory='Food' and this item will save in trns table.
From item_Mast table where MenuCategory='SPML' and all the item_Name will save in Trans table along with Qty entered where Qty >0 in trns Table
Query : How to Create Sub Form/ Grid Format containing item_Mast!Item_Name where MenuCategory='SPML' , and Qty
should be saved as shown in Snapshot of Trans Table. ( Using VBA code)
Attached : (1) Snapshot (Showing Relationship Diagram Form: Item Master , Form : Trns, , Table: Trns)
(2) Unable to attach Ms Access database File, kindly allow the Access File to attach.