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