Stock Control System

Hey again,

Im sorry for starting a new thread, Only I need a different topic name.

Thanks for the help Thomas, from the other thread, though my project has been blown completely out of proportion.
I decided to start from scratch again today. Having no help from the teacher is a major factor because he
knows only very basic database.

My initial idea for the project was to be able to set up a stock control system allowing 1 user, my Aunt to be able
to order shoes, manage stock by checking orders against deliverys and updating the stock records. Also some form of
allowing her to enter sales for particular shoes which would update the stock file.

I started with the tables

- tblStock - IDtype, CompanyID, Quantity, Colour, Size, Reorder

-tblOrder - IDorderNo, IDtype, CompanyID, Quantity, Colour, Size

-tblCompanyID - CompanyID, CompanyName, Address, Telephone, Email

I had the relationships set up so IDtype in tblStock connected to IDtype in tblOrder. I had the CompanyID in
tblCompanyID connected to the companyID in tblStock and In tblOrder.

I then added some models of shoes into tblStock. I created a query adding tblStock, tblOrder and tblCompanyID.
I dragged the whole tables into the query but because of the relationships, when viewing the query, there were no fields there. So upon deleting the relation between CompanyID in tblCompany and CompanyID in tblOrder, the data which I entered into tblStock appeared.

I then created a form based on this query with a combo box with its source set to tblStock allowing me to choose the models of shoes. I then put the other fields in as text boxes and made a confirm button. When the form was open, if I selected a shoe from the combo box the company information didnt appear in the fields. Once I had entered quantity, size and colour, I pressed the confirm button and this added that order into tblOrder, but no CompanyID.

This morning I realised the system should be set up including another table with a list of shoe models the user would be able to order because I had them selecting models which were in stock. I hadnt thought about this when designing the database.

I supposed what I am asking for is any general help into setting up this stock control system allowing it to do the functions that I require for my user.

Any help greatly appreciated

Thanks

Tempest