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
(e-mail address removed)
 
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
(e-mail address removed)
 

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

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Comments/help on database design 5
HOW do I make selections and carry only those selections thru proc 5
Can someone provide me with info on how Office 365 works? 2
write usb flash drive information in to excel cell 6
Combo-Box/Table Issues 1
Database Design 6
List Box Problem 2

Top