Hi,
Is this possible & How ?
We manufacture products. Each product has a list of items which can be
packed at our production facility. A Picking List.
Certain customers may require certain packing items to be omitted from
certain products.
My products table is linked to a ProductPacking Table 1 to Many.
At the moment, Each product has all the packing items listed.
When a customer places an order, I need to select a product and then
specify if all the items are to be packed or only certain items for
this particular job. Each order received by us may have 1 or more
orderlines (each orderline represents 1 product on the order). Each
orderline gets its own job number.
Although I have set up a master packing (pick) list for each product.
Occassionally there may be a time when one customer has ordered
product A with all the items, but another customer has ordered Product
A without a power supply for example. I need to be able to select
either all or partial items at the time of packing and record the
selection in another table for each specific Job Number.
What I need is a form to appear for that product with all the packing
items listed available for that product. Each Item could have a
checkbox. Once completed, I could close the form. The selection would
be kept in a PackingSelection table ?
Appreciate your thoughts
David.
This is required because our production facility can view all our
orders on-line via my asp pages. Each product ordered by any customer
needs to have its own pick list recorded in the database.