update quantity - ALREADY READ ALLEN BROWNE!!

[Turbo910]

Hey guys,
Im really quite new to access 2007, and im trying to build a simple inventory system where a user can bring up the item he/she wants and it automatically shows the quantity of the product, the unit the product is in and the section its in (I also want to show the costs etc in a later date) and can basically changed the quantity of the product selected and it can then save the new quantity value. AS I SAID IN THE TITLE I HAVE READ THE ALLEN BROWNE ARTICAL ON THIS BUT DUE TO ME BEING SO BASIC I DONT UNDERSTAND WHAT HE IS SAYING. So heres my problem...


Basically i have a table (Product_tbl) with the following fields:

• Product_ID
• Product_Name
• Product_Qua
• Unit
• Section

And a second table (Cost_tbl) with the following fields:

• Cost_ID
• Product_ID
• Job_price
• Rent_price
• RRP
• Actual_Selling_Price

My only relationship is a one-to-many from Product_ID in the Product_tbl to the Product_ID in the Cost_tbl.

So far a have a combo box for the Product_Name and 3 text boxes linked to the combo box to show quantity, unit and section.

Now i need simple instuctions of how to enter a new quantity of the product selected in the combo box into a text box somehwere else on the form or into the same textbox the quantity on hand is shown in, and have the new quantity saved to the original record ( so not making any new records)

Thanks in advance

 

[HiTechCoach]

... im trying to build a simple inventory system ...

IMHO, there is no such thing as a simple inventory system to track quantity ion hand.

... Now i need simple instuctions of how to enter a new quantity of the product ...

Normally you do not enter a new quantity by editing the quantity data. There is no aduit trail or accountability. Do that does not follow good programming or accounting principles. It open a huge for for errors!

You should create a new transaction record that adjusts the quantity + or -. That is what Allen Browne is trying to explain.

 

[Turbo910]

OK so can you help me do this in simple english language? lol its just eveyone uses jargon to me and then i still dont understand. Literally a step by step guide for me to do this??

Thanks

 

[Uncle Gizmo]

>>>eveyone uses jargon to me and then i still dont understand. Literally a step by step guide for me to do this??<<<

If you wish to avoid the jargon, then you have two choices, either develop your own stock management system on paper, the easiest way to do this is to work with your company personnel , make a note of the records they keep, invoices, delivery notes, and the like and from this you will see and understand how the existing stock control is handled.

If you are not actually working with an up and running company, then it is slightly more difficult as you have to use your imagination and develop the process, again committing it to paper.

Once you have a working paper work system, then you need to examine it and it should become clear what needs to be stored in the tables, what needs to be calculated with queries. The forms you developed on paper are very likely to become models for your forms within MS Access. (there are many posts around on how to develop through this stage and technique)

The other method, your second choice, is to start developing straight in MS Access, however it is unlikely that anyone will give you instructions in advance, not because they don’t want to, but because it’s just not feasible. What people will do is help you when you become stuck. You will become stuck when you have made an attempt, in other words you have shown yourself willing, you will also gain knowledge and the questions you start to ask of the forum will generally be of a nature that can be answered easily.