new to Access help with tables

[Guest]

Hello All,

I need some help in creating table fields

I need to work on a purchase order management which tracks qty based on line
times and tracks shipped qty and received qty

I have to track the total qty received against the line item and calculate
the present stock for that item.

any suggestions.

 

[Guest]

Sorry, I forgot to include the hyperlink

http://office.microsoft.com/en-us/templates/CT101426031033.aspx

 

[Guest]

You might want to take a look at some of the MS templates, they might get you
off to a running start and save you a lot of frustrations.

 

[Guest]

Thanks Daniel,

I am looking for a specific requirement. I have to enter purchase order
data. I have already created an item master, purchase order master and
inventory. I have to track qty changes per line item for qty received and qty
shipped.


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