R
ramyaamer
Currently I am working in purchase order DB
The tables involved in this db is
1-Supplier (SupplierID, Supplier Name And all other data related t
supplier)
2-Items (ItemID, Description , SupplierID And all other data related t
Purchased Items)
3-Order ( OrderID, SupplierID, Date,…etc)
4-Order Details (OrderID ,ItemID, Quantity, Price,…etc)
I think now all of you can imagine my db main design ,
The form for this Purchasing if main form has the Order table an
suform have the order details table.
The supplierID in the main from and ItemID in the subform is a comobox
I need to reduce the Items in Item Cobobox to the only items that th
selected supplier in the main form…….! Any one Can Hel
The tables involved in this db is
1-Supplier (SupplierID, Supplier Name And all other data related t
supplier)
2-Items (ItemID, Description , SupplierID And all other data related t
Purchased Items)
3-Order ( OrderID, SupplierID, Date,…etc)
4-Order Details (OrderID ,ItemID, Quantity, Price,…etc)
I think now all of you can imagine my db main design ,
The form for this Purchasing if main form has the Order table an
suform have the order details table.
The supplierID in the main from and ItemID in the subform is a comobox
I need to reduce the Items in Item Cobobox to the only items that th
selected supplier in the main form…….! Any one Can Hel