ACCESS DATABASE HELP NEEDED

[Guest]

Hi All,

I am trying to create a database table for a purchase order inventory system
which tracks items issued in & issued out.

I have designed the following tables

Item master


PRODUCT ID - UNIQUE PRIMARY KEY
DATE
DWG NO , PART NO, PROJ NO, LOCATION


PURCHASE MASTER

PURCHASE ID - UNIQUE
PO NO
ITEM DESC

INVENTORY

INVENTORY ID
PURCHASE ID - FOREIGN KEY
PRODUCT ID-FOREIGN KEY LINKING THE ITEM TABLE
PROJECT QTY, QTY RECEIVED, QTY SHIPPED,PO NO

DO I HAVE A LINE ITEM TABLE . AM I IN THE RIGHT DIRECTION.

THANKS
VANDY

 

[Guest]

Here is a library of data models. perhaps one works for you.
http://www.databaseanswers.org/data_models/index.htm

 

[Steve]

Take a look at the Northwinf sample database on your harddrive.It is an
order entry system.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)