im creating a stock ordering system for supermarket, but only for ordering not selling. so far i have created these tables with the relationship in the attachment. Can you tell me if its right or wrong. Also my system also needs to store details of general stock in the supermarket including product code item price etc. Also i need to show the amount of general stock reaming at one time from when the data arrives to when stock used has been entered. How am i meant to do this, do i need to create a seperate table for general stock or something?

I would recommend reading this post here by allen browne. (http://allenbrowne.com/AppInventory.html)

but i dont understand, the product id i have now is for department stock but there is only general stock which i have to keep a track of quantity. how can i do this plz?

>>>the product id i have now is for department stock<<<

Do you mean this field?
Item Type / Department

i have uploaded the database can you check it and tell me whats wrong thanks

>>>the product id i have now is for department stock<<<

Do you mean this field?
Item Type / Department

I can't help if you don't answer the questions

no im not talking bout that, but how to include general stock in my database. ive uploaded the database so you can see what ive done.

.
Sorry, I didn't realise you had changed your question.

I suggest you start a new thread for your new question.