a beginner need help

[richardplr]

Hi,

I am just a new greenhore learning ms access and I am planning for a warehouse/inventory storage database.

My question :

1) I have 4 product division (Do you think it is good to have 4 tables)
2) The calculation field. (How does the mechanism work when I take the the item out from the inventory, it will show as total storage -1 (eg, the storage have 5 units and I took 1. it show balance left 4).

About question 2, is it that I have a to do separate table again.

Temporary, I have these 2 problems and hope all access expert can help.

Regards,
Richard

 

[The_Doc_Man]

1. This forum has an excellent SEARCH function in the menu bar, 3rd from left. Look up "Inventory" and "Normalization" before trying to implement too much. I could spend tons of time but the search function probably will help you much better.

2. You probably do NOT need multiple tables for multiple product divisions. You would make the division just another field in the overall product table.

3. Keeping a running inventory balance is a trick beast on the best day of your life, but that topic has been addressed in the forum many times. Again, search for "Inventory" in the forum. You never actually take ANYTHING out of an inventory in terms of the records. What you do is store transactions where you put in or take out objects. The running balance of all transactions for a given product is your instantaneous "on hand" at any time.