Hi there People,
I need some suggestions, I am working on a database for the company i work for - it is a home textile exporting firm - everything is just fine up to this point - the problem i am having now is that they way i have designed the database is like this:
DATA FLOW:
Order placed - (by buyer)
Then
Fabric Requistion placed (by production dept. based on the order)
Then
Fabric received (In factory)
Then
Fabric issued to cutting dept.
Then
cut fabric issued to stitching dept.
Then
complete item issued to packing dept.
Then
packing dept. ships goods.
If everything goes accordingly - my design is fine - but the problem is that at any stage anything can be shipped - depending on the order - e.g. Raw fabric can be shipped, Cut Fabric can be shipped etc.
does anyone have a suggestion as to how i should go about this.
Bert.
I need some suggestions, I am working on a database for the company i work for - it is a home textile exporting firm - everything is just fine up to this point - the problem i am having now is that they way i have designed the database is like this:
DATA FLOW:
Order placed - (by buyer)
Then
Fabric Requistion placed (by production dept. based on the order)
Then
Fabric received (In factory)
Then
Fabric issued to cutting dept.
Then
cut fabric issued to stitching dept.
Then
complete item issued to packing dept.
Then
packing dept. ships goods.
If everything goes accordingly - my design is fine - but the problem is that at any stage anything can be shipped - depending on the order - e.g. Raw fabric can be shipped, Cut Fabric can be shipped etc.
does anyone have a suggestion as to how i should go about this.
Bert.