Basic Help Design Simple POS Database - Suppler, Inventory, Sold Tables?

[Dormie]

Hi, Thank you for any help in advance.



I'm looking for a little direction in how to design a very basic database to be used as a simple Point of Sale system. I've setup a couple of sample sheets however I'm questions the designs of them and before moving forward I'm looking for ideas of how others would setup something like this.

I've looked at northwind and it's very complicated, much more then I need.

Basically, I receive individual products from ruffly 50 suppliers, each product is different, therefore my quantities are always one. Suppliers sell me things when they want to move them so, I have no need for a re-order type system as I never know when or what I'm receiving.

My previous attempts have had Supplier Table, Inventory Table (with a purchase price, sold price, sold date columns, etc), I've then queried Inventory Table on sold items to get the breakdown of sales. However, now I feel this maybe a round about way of doing things and I should have a sold table...... I'm definitely not sure how I would populate the sold table from the inventory table through a form. If that's even how you would handle it.

Basically any direction in design/functionality would help.

Thank you!

[ranman256]

tSold table.
--------------
ItemID -the item from tInventory (also mark it in tInventory as sold)
SoldToID
DateSold
(and any other notes needed)

[Dormie]

Thank you for the response ranman,

You are saying to make a sold table?
Table Setup:
tSold
tInventory

Should I use a form to update tInventory along with add row of sold ItemID info to tSold?

[Dormie]

Could someone explain a little more how to properly set up database with tinventory and tsold tables work together.

I'm a little confused on how someone from my tinventory table makes it into the tsold table. Does it physically get moved? Do you make a new sold item with a id that references your tinventory? Is this all done through relationships? I've looked over some diagrams however I feel they are so much more complex then my basic need. Which is tinventory, tsold, tsupplier.

Sorry for the basic questions...

Thank you in advance!

[orange]

There are some links posted here that will help you with concepts and design.
Good luck.