Database Design

[pat15]

I am making an inventory database

which I will have every single item in the database with its own serial number.

The items will be shipped out, some will be returning by RMA.


Is it better to have all the items in one single table?

or have two table , tblItemIn abd tblItemOut.

 

[pat15]

Nevermind

I just made an extra field(In : yes/no) on the tblItem