Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Item Movements

Author  Topic 

mody82
Starting Member

13 Posts

Posted - 2009-02-24 : 03:38:13
Dear All
I have a project about Stocks , and I create the most tables such as Customers,Branches,Items & ....
My Question is I want to craete a table for the Warehouse (Invetory) which holds the movements of the items ,
So what's the main column to define this table ?

Best Regards

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-02-24 : 06:35:58
Business rules should define that.
Go to Top of Page

mody82
Starting Member

13 Posts

Posted - 2009-02-24 : 07:37:30
Thx Sakets ,
but if you can explain more I'll appreciated
Go to Top of Page

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2009-02-24 : 07:40:02
Speak to the person you are making the project for and ask them how they want the movements of the items to work and act accordingly :)

hth
Pace

"Impossible is Nothing"
Go to Top of Page
   

- Advertisement -