First Timer: Product Inventory Table

I'd need to know more about the structure of your database overall, and how you wish to manage inventory.  Does your database include purchase and sales orders for instance, and if so how are they modelled?  Do you wish to treat each product, regardless of supplier, as a single inventory category, or do you wish to maintain separate inventory data per supplier for each product supplied by more than one supplier?

A fully developed inventory management database is a complex affair, and there are commercial inventory management products available whose functionality would take a lot of time and effort to reproduce in an Access application, even if you have the skills to do so.  Unless you only require a simplified system with limited functionality, purchasing a commercial application will often be a more sensible business option than trying to reinvent the wheel.

You'll find an example which illustrates the basic methodologies of a simple inventory management database as Inventory.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.

This little demo file is not intended to be a working application, however, but only a starting point to provide some basic guidance in what would be involved in the development of an operational database.  It does not include purchase orders, only sales orders, and treats stock acquisition generically, with no supplier data whatsoever.  Like all my demos, it assumes that anyone consulting it will have sufficient technical knowledge of Access development to be able to apply and adapt the methodologies to their own requirements.

Ok i already try it and its works but i have another questions..how to track the inventory records?

Can u simplified for my better understanding?

For future reference, please do not piggy back a question on an old thread, but start a new thread and include a hyperlink to any earlier thread to which you wish to refer.

Where a product can be supplied by more than one supplier, and a supplier can supply one or more products there is a many-to-many relationship type between products and suppliers.  A many-to-many relationship type is modelled by a table which resolvers the relationship type into two one-to-many relationship types.  In broad outline the tables would be like this:

Products

….ProductID  (PK)

….ProductName

Suppliers

….SupplierID  (PK)

….Supplier

….etc

And to model the relationship type:

ProductSuppliers

….ProductID  (FK)

….SupplierID  (FK)

….Price

The primary key of ProductSuppliers is a composite one of the two foreign key columns.  Price is an attribute of the relationship type, so is a column in this table.

i have a problem.. what should i do for 1 product that have many suppliers.

its not easy for me to track inventory for 1 products because i didn't know how to resolve this problems. RM(Ringgit Malaysia)

Example:

product name : MATILDA COSMETICS

price sell : RM 120.00

supplier A: price RM 57.00

supplier B: price RM 48.00

can somebody resolve for me?

i have many products that need to be check for the stocks but I'm sucks on this..

You replied to a 4 year old post that had already been answered.