Newbie question: how/where to input data

[jking.mails]

Hello, I am a newbie to access and I learn access all by myself. I understand concepts of database and is proficient with computers e.g., excel, word, c++ etc.

However, I am confused now. I only want to build a invertory database. So I built tables of Category (list of brands), and Products (each line is a pair of category and product name).

Now I want to input the sales data, e.g., on which day what product of what category has been sold for how many and how much. Also, I want that the person who do the input can select the category and the products of the category from drop lists. So I created a form with these information.

Then I don't know where to input the sales data of each day. In the form or to create a new table? Please help.

 

[jking.mails]

file

I attached the file, stock-test.mdb. Note, the Products table mentioned above is named as stock in the file.

I thought to input sales data in the form sale2, but found when I input a new record, productname is always a list of the last record no matter the current category is changed. So I started to wonder whether the form sale2 was the right place to input data.

Please advise. Many thanks.

 

[jking.mails]

BTW: I use office 2007. Someone said my file works on 2003. How to make the dependent combo work on 2007? Thanks.