D
dennisW
I'm Working on a ~ simple database to track in-stock inventory, orders placed
+ ordered items received. The P.O.# on the boxes (generated with orders from
corp. ordering software) helps but with everyone in the lab placing orders,
still confusing as the boxes are received. We also get caught with no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked Northwinds &
on-line examples - awesome examples & links but not able to use this to solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to see
ordered items not yet received + # currently in stock so it's clear if no
need to order more of that item. I also want to enter info from corp.
ordering software to create new Order records and I want to see this on the
same form. (I'll delete the Order records when items arrive after increasing
lab inventory). I used a list box on the form to show current orders (Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create a new
Order table record: user selects from the Product table records, if one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming errors or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box (Product
table or qry) hoping I can select the Product item, enter other order stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list (no
edit) from 1 source then select a record from 2nd source (or create a new
record in 1st table if not a 'stock item' in 2nd table) and add it to 1st
table? Once done, I hope to be able to change copy & this to make "Items
received-add to inventory" selection. Scrambling to learn some some VBA so
I can use this if I need it. I saw advice to calc inventory using changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.
+ ordered items received. The P.O.# on the boxes (generated with orders from
corp. ordering software) helps but with everyone in the lab placing orders,
still confusing as the boxes are received. We also get caught with no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked Northwinds &
on-line examples - awesome examples & links but not able to use this to solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to see
ordered items not yet received + # currently in stock so it's clear if no
need to order more of that item. I also want to enter info from corp.
ordering software to create new Order records and I want to see this on the
same form. (I'll delete the Order records when items arrive after increasing
lab inventory). I used a list box on the form to show current orders (Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create a new
Order table record: user selects from the Product table records, if one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming errors or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box (Product
table or qry) hoping I can select the Product item, enter other order stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list (no
edit) from 1 source then select a record from 2nd source (or create a new
record in 1st table if not a 'stock item' in 2nd table) and add it to 1st
table? Once done, I hope to be able to change copy & this to make "Items
received-add to inventory" selection. Scrambling to learn some some VBA so
I can use this if I need it. I saw advice to calc inventory using changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.