new to Access help with tables

V

vandy

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.
 
D

Daniel

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.
 
V

vandy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top