create user interface from table

[mer]

Hi all!!! I m learning access 2007 by myself and doing a project which sounds like inventory system.

I have encountered a problem here.
My table will included all details which the stock will come in and go out from the storage.
And now i wanna create a user interface from the table i mentioned which will allow user to key in stock in and stock out data in 2 different forms.
Can i break the table into two small tables which contain (a) Stock In and (b) Stock Out data??? So that i can create form of interface frm those small tables??


How am i gonna to do this???
Please help.

Thanks in advance!

[alansidman]

Why would you want to split the table and further have two input forms? This can all be achieved in one table and one bound form. Your rationale for this would help getting you a functional answer. What are we missing?

Alan

[mer]

what do u mean by bound form??? sorry if i made u confused.

However, I would like the user to enter data of stock in and out seperately in two different tables. So that its more convenient for them to check whether the stock is in or out. Because now if the stock is in, the transaction quantity will be positive value while the stock out value will be negative. In the end, they can sum up to know current item on hand.

[alansidman]

Forms that are bound to tables automatically update the tables when either the user moves to a new record or the form is closed. It is commonly used in Access.

What you are trying to do is achievable, but seems to be out of the ordinary. To achieve what you want, you will need to build a query for inventory additions and then run it as a make table query. Next you will have to do the same for inventory additions.

You will now have two tables.

[mer]

oh thanks and i have tried this way.

However, i noticed that when i want to add the data into the 2 tables ( built by query), i dun have the data updated on the main table i use to calculate the sum of items on hand.
Thanks for your time.

[mer]

To make things easier and then we can understand better about this problem, I attached my file here.