access 2003

T

tindatrue

dear friends, i want to make database as follwos
manufacturers their products with pricing and other details
note there are more than 20 manufacturers and more than
1000 product they have,

can someone guide how to organize my DB in access 2003
rgds
--
 
S

Steve

Here's a start:
TblManufacturer
ManufacturerID
ManufacturerName
<<Fields for Contact Details for manufacturer>>

TblProductType
ProdyctTypeID
ProductType

TblProduct
ProductID
ProductTypeID
ManufacturerID
ProductDescription
ProductPrice
<<Other fields for product details>>

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
T

tindatrue

Dear Friend many thanks for your kind reply
please let me know how to make relation with
these tables ??

Rgds
 
S

Steve

Join ManufacturerID from TblManufacturer to ManufacturerID in TblProduct and
ProductTypeID in TblProductType to ProductTypeID in TblProduct.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top