Inventory forms question(s)

  • Thread starter Thread starter pj.parsaie
  • Start date Start date
P

pj.parsaie

I am trying to use a database to help with order tracking, ordering
forms and such. I was thinking of importing all the static data from a
spread sheet (all the stock numbers, costs ect.) currently in use. My
question is how would I go about having a orderform that is saved based
on the date ordered? If I have all the data comming in from a table or
tables, wouldn't the data all be save to the original tables? Also, I
made a template report for printing, we use a specific form to request
supplies and such, how can I have the ordered items from the entire
list only carry over the items that have a number in the qty ordered
feild be carried over? I was thinking of using a subform to hold the
original data. I know this is alot to ask, but is there somewhere I can
go to get help/ideas? Thanks
 
Add a second table for the orders. Set a one-to-many relationship from
master list to the orders table.

In the main form show your basic information - location, QTY Onhand, Stock
Level, Unit of Issue, Order Level, Unit Price, etc.

Use a subform for the order - Order Date, EDD, QTY, Deliver QTY, Due In,
Remarks, etc.
 
Back
Top