access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
--
 
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
(e-mail address removed)
 
Steve said:
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
(e-mail address removed)
Click to expand...

--
Steve, you have one of two choices:
-- Tell us you will stop advertising here, or...
-- get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html
(Until now 2495 pageloads, 1837 first-time visitors)

FYI: (this is also to inform those who do not understand...)
This is *not* about the sigline...although we do not 'love' it, we don't mind the current sigline.
But we will simply continue to hunt down *each and every* of your posts.

It is not relevant whether you advertised in *this* particular post or not...
Your pattern is: You post a few 'good' answers and then start to advertise again.

These groups are *not* your private hunting grounds!
You should know this by now.

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

Rgds
 
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
(e-mail address removed)
 
Steve said:
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
(e-mail address removed)
Click to expand...

Hey Steve,

Look at the stats (Statcounter.com) to see the damage you have done to yourself.
Every time the link is shown, more and more people are reading about you.
http://home.tiscali.nl/arracom/SteveStats.html

Since you have been posting 'nice' the last couple of days the 'answering-machine' stops for now.
We will be watching you though...

ArnoR
 
Back
Top