Stock Inventory Design

[plowe]

Hi,



At present, we have a stock database using access.

We list individual items and each has a stock id#

A lot of the items have common fields, which we now would like to be represented by a single product.

IE:

Item comes in, user selects item type, selects part number, item then added to stock with a stock ID#

So in my mind, we would have min 3 tables : Product - Item - Part number

When a new item comes in, ie not listed on system as a part number, we can add part type, with the details required and the part number.
This is then selectable when adding a new item onto the sytem in future ie additonal qty.

I have tried setting this out in access, but am struggling creating the right relationships / lookups.

Any help would be appreciated.

[orange]

There are various models at www.databaseanswers.org

Here is one that may help
http://www.databaseanswers.org/data_...tail/index.htm

[plowe]

Thanks Orange.

After a bit more thinking, i decided i was trying to get the tables to do too much work.

I have made some headway, but am now a little stuck with cascading list boxes.

[orange]

It is Cascading COMBO boxes.
You can see video tutorials here
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Good luck

PS Tables store data.