Stock Managment Database Design

[chuki2]

Hello all,i need a help....



I have 4 table

1)tblCustomer
2)tblStock
3)tblSales
4)tblPost


In my formPurchase,i can select name then add item to buy...So how i can do it?



1) Keep customer name,address and contact number

2) Keep item,description item,stock,factory price and sale price

3) Keep quantity item purchase,date purchase

4) Keep name courier,post date and number tracking

This is my relationship




Like this? or im wrong...?

I need idea to build it....

[June7]

Not sure why you have the idCust in tblPost

[chuki2]

Because one customer can see many posting....

Then one posting can see many item buying....

Can do that?

[June7]

Hard to read that image. What is it you are posting? The sale? The sale is associated to customer and the sale is associated to posting. You get customer/posting association through the sale. If this is not correct understanding, please clarify your schema logic.

Also, now see that customer is linked to Stock, not Sale. Relating customer with sale makes more sense to me.

A sale has goods and a customer and is posted. Will each post have more than one sale? Can each sale have multiple stock items? Consider:

tblSales
SaleID (primary key)
CustID (foreigh key)
SaleDate
PostedBy
TrackingNumber
PostDate

tblCustomers
CustID (primary key)
name, address, etc.

tblSalesDetail
SaleID (foreign key)
StockID (foreign key)

tblStock
StockID (primary key)
description, price, etc

[chuki2]

Ok thanks for help...i got it...