Yet another stock/inventory control thread

[Gazza2]

Firstly let me apologize for starting another thread on this subject.

I have been reading the posts on here about stock control and got myself into a right muddle and need a bit of help.

Firstly i have started a database and am now at the point of stock control, I created tables for the different types of transactions(sales, returns, Purchase orders etc) and also had seperate matching tables for the details ( ie saleslines,returnslines purchaseorderlines etc), but after reading the posts on here it seems that the best solution is to have a transaction table which would include all the lines from different types of orders.

Is this correct?

Also i am then stuck on how to create the forms and relationships.

At the moment i have a main form with a combo box to select the customer and other textboxes that autofill including the document ref no ( ie InvoiceNo, PurchaseOrderNo etc) and a subform Based on the details table so i can enter many lines on an order and this table is related to the main table for that type of order, if i have a transaction table how would i relate that to the main table?

I apologize for the long post and hope it makes sense to the gurus on here as it definately doesnt make sense to me.

Thanks in advance for the help

Gareth

 

[gemma-the-husky]

try this MS inventory database - its really pretty good - i used it as a base for a commercial system

it should give you some ideas how to implement these ideas

http://office.microsoft.com/en-us/templates/TC010184581033.aspx?CategoryID=CT101426031033