spcepickle
Registered User.
- Local time
- Yesterday, 21:26
- Joined
- Jan 8, 2008
- Messages
- 30
Hey All - I have inherited a huge database that needs to be cleaned out.
The database is used to keep track of what is in our warehouse. Every container that comes in is given a number and every item coming out the container is given a unique id number. Then things are billed out to people via orders that pull from several containers.
So I can only clear out orders where every item on the order comes from a container where every item has been billed out. This is what I do not know how to do.
I would be happy to e-mail anyone the database (I can not seem to attach it).
As a side note the guy who originally programmed the database lives in Haiti so some of it is in French.
The database is used to keep track of what is in our warehouse. Every container that comes in is given a number and every item coming out the container is given a unique id number. Then things are billed out to people via orders that pull from several containers.
So I can only clear out orders where every item on the order comes from a container where every item has been billed out. This is what I do not know how to do.
I would be happy to e-mail anyone the database (I can not seem to attach it).
As a side note the guy who originally programmed the database lives in Haiti so some of it is in French.
