Inventory/Warehouse Control

[Maker]

At first I planned to download a template DB on inventory control, but then decided to start from scratch.

DB I want to build should do the following:

1) Register Inventory Items list based on Category, Sub-Category and Sub-Sub-Category
2) Register inventory items coming IN
3) Register inventory items coming OUT
4) Generate Status Check based on selected items
5) Notify item shortage based on numbers left in stock (=< than X)

I am trying to figure out Relationship Diagram.

Besides, I have learned from Internet that Access is NOT friendly on dependent drop-down lists. Data validation during table filling is crucial for me. Besides, I need dependent drop-down lists during query generation.

[Access_Blaster]

Check here #64 under Inventory Control

[NoellaG]

Hi,

in the attachment you can find some database diagrams of a warehouse database that is used in a cold storehouse in the harbour of Antwerp. The back-end is SQL server, the front end Access.
It might give you some inspiration.

succes
NG

[Maker]

Hi,

in the attachment you can find some database diagrams of a warehouse database that is used in a cold storehouse in the harbour of Antwerp. The back-end is SQL server, the front end Access.
It might give you some inspiration.

succes
NG

Access_Blaster and NoellaG, thank you very much!