clothing inventory (sales purhace) database relations

[Guest]

I know something about access but i got always stuck about laing out tables
and setting relations. can you point me into rieght direction?
i need info about:
products i have like one style and then there is different sizes and colors
those are ordered
and sold
i do not need customer database so just kind of sinple way keep tracking
sales and purhace (orders also) and then see whats in stock for easy.
Thanks for help

 

[Allen Browne]

This is probably a little more involved than you realize at this point.

For starters, you will probably need these tables:
- Manufacturer
- Label
- Supplier
- Style
- Season
- SizeType
- Size
- Color
- PurchaseOrder
- PurchaseOrderDetail
- StockReceived
- StockReceivedDetail
- Sale
- SaleDetail
- Customer

Most of those will be obvious, but a couple may need explanation. There are
several different methods of sizing, e.g.:
6,8,10,12, ...
XS, S, M, L, XL, ...
children's sizing etc.
That's why you will need a SizeType table.

Likewise, the stock actually received is not necessarily the same as what
you placed on your purchase order. You may get some of what you ordered, the
whole order, or some may never be sent (e.g. discontinued lines.)

You may also need to handle orders (as distinct from sales), and possibly
accounts (e.g. where clients buy on invoice, receive monthly accounts), and
receipting (for cash, accounts, prepayments, partial payments, ...)

 

[Eric J Hoagland]

I know something about access but i got always stuck about laing out tables
and setting relations. can you point me into rieght direction?
i need info about:
products i have like one style and then there is different sizes and
colors
those are ordered
and sold
i do not need customer database so just kind of sinple way keep tracking
sales and purhace (orders also) and then see whats in stock for easy.
Thanks for help