Need Suggestions (1 Viewer)

Bert666

Registered User.
Local time
Today, 13:40
Joined
Jan 9, 2003
Messages
34
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.
 

WayneRyan

AWF VIP
Local time
Today, 13:40
Joined
Nov 19, 2002
Messages
7,122
Bert,

I think the following would work:

tblOrders:
OrderID
OrderDate
CustomerID

tblOrderDetails:
OrderID,
DetailID

tblOrderEvents:
OrderID,
DetailID,
EventName, (Based on combo - OrderPlaced, Requisition ... shipped)
EventDate

I am not familiar with your app, but this structure allows for
many orders, each consisting of many items. Each item may undergo
many "events" prior to being shipped.

This should allow you to reconstruct the chronology in a detail
report. Additionally, the queries to detect which items, or
even entire orders, have NOT been shipped yet.

Just some thoughts ... Maybe this will get some of our other
members started on this, I've seen it sitting idle for a while.

Wayne
 

Users who are viewing this thread

Top Bottom