Stock Table structure

From: "SF" <ssamnang@xxxxxxxxx>
Date: Tue, 16 Jan 2007 15:14:22 +0700

Hi,

I want to setup an inventory dabase and I was not sure what structure to
adopt. Below are two options, hope that someone would advice

Option 1
I just add another typTransactionType that will list all type of transaction
eg Sales,Purchase, Return

tblTransaction
TransactionID Long PK
TransactionDate Date/Time
CustomerID Number
TransactionTypeID Number

tblTransactionDetails
DetailsID
TransactionID Foreign key
ProductID Number
Qty
Unit
UnitPrice

Option 2

I need to set up two tables for Purchase, Sales, Return etc...

tblPurchase
TransactionID Long PK
TransactionDate Date/Time
SupplierID Number

tblPurchaseDetails
DetailsID
TransactionID Foreign key
ProductID Number
Qty
Unit
UnitPrice

tblSale
TransactionID Long PK
TransactionDate Date/Time
CustomerID Number
TransactionTypeID Number

tblSaleDetails
DetailsID
TransactionID Foreign key
ProductID Number
Qty
Unit
UnitPrice

.

Follow-Ups:
- Re: Stock Table structure
  - From: Allen Browne

Prev by Date: Re: Find and Replace in the Whole Base
Next by Date: Re: Stock Table structure
Previous by thread: Re: Pulling only Newest Child Record
Next by thread: Re: Stock Table structure
Index(es):
- Date
- Thread

Relevant Pages

Re: using find in subform
... Also the listbox in Form1 is called ... >>ProductID Autonumber ... >>TransactionDate Date ... >>The Supply Request form Record Source is from Supply ...
(microsoft.public.access.formscoding)
Re: Stock Table structure
... TransactionTypeID to use 1 and -1) until reading your comment below. ... TransactionDate Date/Time ... TransactionID Foreign key ... ProductID Number ...
(microsoft.public.access.tablesdbdesign)