G
Guest
Using A2003 I am working on a Sales and Purchasing db for my company. Sales
are reasonably straight forward as I've adapted some of the Northwind objects
to suit. Purchases, however are a different matter.
I've created the Orders and OrderDetails tables with appropriate fields.
What sometimes happens is that a Supplier may not be able to fill an order
completely. That is, some items may be placed on backorder for supply at a
later date.
EG: ordered Widget x 5 but only receive 3, backorder is 2.
What I want to see happen is when the backordered items do arrive, I pull up
the original order that only has the backorder showing and receive those
widgets then.
I'm thinking an Append query to move any backorders to a "temporary" table
that the purchase order would call from when I receive the backorder/s. Once
that backorder has been filled run a Delete query to remove the backorder
from the "temp" table.
Any thoughts??
Don, Sydney Australia
are reasonably straight forward as I've adapted some of the Northwind objects
to suit. Purchases, however are a different matter.
I've created the Orders and OrderDetails tables with appropriate fields.
What sometimes happens is that a Supplier may not be able to fill an order
completely. That is, some items may be placed on backorder for supply at a
later date.
EG: ordered Widget x 5 but only receive 3, backorder is 2.
What I want to see happen is when the backordered items do arrive, I pull up
the original order that only has the backorder showing and receive those
widgets then.
I'm thinking an Append query to move any backorders to a "temporary" table
that the purchase order would call from when I receive the backorder/s. Once
that backorder has been filled run a Delete query to remove the backorder
from the "temp" table.
Any thoughts??
Don, Sydney Australia