Temp Selection Table....

[David]

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 PackingSelectio n 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.

[Steve Jorgensen]

I believe what you are talking about is something like a system configurator.
You start with a BOM (bill of materials) having some components flagged as
optional, then when the customer places an order, the default options are
added (by copying from the optional BOM items) as detail records connected to
the order line marked as included by default. The order taker can then
uncheck the Include box for any of those that will be omitted. Now, the order
has all the info you need to figure out what to pack and ship.

On 4 Oct 2004 08:09:03 -0700, da***@scene-double.co.uk (David) wrote:

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.
Occassionall y 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 PackingSelectio n 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.

[David Gordon]

Hi Steve,

Thanks for resopnding.

This is what I want to do.
How do I do it.
I'm pretty good at Access and have created a complete front-end order
processing & tracking system linked to a Back-End MySQL/asp application.

I am just a bit confused on this.

Lets say customer X ORDERS PRODUCT A.
I press a button on the order form and all the packing items are listed
and ticked by default. I can then keep all line items or de-select any.
once I hit a 'Load' button, the ticked lines are then loaded into a
packing table linked to the job number for that orderline.

How do I save these lines to the packing table ?

David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!