order deliveries design help

[glen]

Hi Friends,
I need help from you guys in creating a database.
I will give u details.
Database is for order deliveries.
Suppose I have to deliver orders to two factories Factory (A) and Factory (B).
All departments are same like Production, Costing etc. in both factories.


I have these fields:
1 Department
2 Location
3 items
4 UOM (Unit of measuring)
5 Quantity
6 Date Issued.

Please make a database for me in these fields.
Thanks in advance.

[RuralGuy]

Your request is beyond the scope of these Forums. We can assist you if you get stuck but I would suggest looking at the templates on the Office site and see if there is something close to what you want that can then be modified. Good Luck.

[glen]

Can i attach my file here ?
And you guys can modify for me?

[orange]

There are existing data models that may help

http://www.databaseanswers.org/data_...ders/index.htm
http://www.databaseanswers.org/data_...ries/index.htm
http://www.databaseanswers.org/data_...ries/index.htm

The purpose of the forum is to offer advice, suggestions, criticism, point to potential answers, approaches, similar situations, concepts....but not to do/create and application for you.

If you need help with a specific concept or approach, just ask.

Here is a list of things to do/consider in approaching a database design.
http://www.databaseanswers.org/approach2db_design.htm

Other topics of interest/relevance at this point

Normalization http://www.rogersaccesslibrary.com/T...malization.zip
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip
Database Principles http://forums.aspfree.com/attachment...achmentid=4712

Good luck with your project

[glen]

Thank you very much friend.
You solve my problem.