A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Part and Product Database Help



 
 
Thread Tools Display Modes
  #11  
Old February 27th, 2010, 08:08 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Part and Product Database Help

If you need your database up and running quickly, I would like to offer to
create your database for you. I provide help with Access, Excel and Word
applications for a small fee. If you want to work together on this, contact
me.

Steve



"mglg01" wrote in message
...
and what would the Primary Key be for the ProductPartsTbl? Or do I not
need
one?

"John W. Vinson" wrote:

On Mon, 15 Feb 2010 10:25:01 -0800, mglg01

wrote:

I need help designing a database for parts and products. I'll give you
a
brief description of the scenario:

There are thousands of parts, and hundreds of products. I want a
database
that has the following:
-a list of the parts - with description, product number, color,
length,
etc.
-a list of the products with the associated parts included in the
product
-If I change a description of a part, I want it to change in the
products and all related aspects

I know I need a part table, but I don't know how to incorporate the
products
- because the parts can be used for more than one product.

Any help, comments is greatly appreciated!

Thank you


There are several possible scenarios here. A typical scenario is that
each
Product consists of many Parts, and each Part can appear in many
Products;
this needs three tables -

Parts
PartNo primary key
Description
Color
other part attributes

Products
ProductID primary key
ProductName
other attributes of the product as a whole

ProductParts
ProductID link to Products
PartNo link to Parts
any info about this part as it pertains to this product, e.g. number
needed

A Form to enter, display and edit this could consist of a mainform based
on
Products with a subform based on ProductParts, with a combo box to select
the
part; the combo could contain multiple fields for the different part
attributes.

If a Part can itself consist of other Parts, or if one Product can be a
Part
of another Product, you'll need Fred's BOM solution.

--

John W. Vinson [MVP]
.



  #12  
Old February 27th, 2010, 08:27 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Part and Product Database Help - replied by Losers R US

"Steve" wrote in message
...
If you need your database up and running quickly, I would like to offer to
create your database for you. I provide help with Access, Excel and Word
applications for a small fee. If you want to work together on this,
contact me.

Steve







Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.