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  

Changing Part-Number (Primary Key)



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2010, 02:03 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Changing Part-Number (Primary Key)

My background is running smaller engineering and manufacturing intensive
companies where we deal heavily in part numbers.

Regarding your database question, I would echo Jerry's answer. Anytime
that a field can be "messed with" by outsiders (in your case, the part
number) I would recommend not having it be the PK.

Regarding your company's number changes, it's behavior per your first
paragraph "For example Part ABC-100 might be changed to ABC-200 and the key
ABC-100 may be used for another part. violates "Part Numbering 101" and
basically makes the part numbers meaningless.

The description of behavior in your later paragraph "There is a white
envelope that measures 6” by 10” and the part-number is ABC-101. A switch is
made to a new supplier and part ABC-101 is replaced by an off-white envelop
that measures 6” by 10.1”. " is incomplete/ambiguous regarding what you are
actually doing in that case and so I can't comment on it.

Your company needs to start by defining what "part number" actually means to
it...that definition should have some enduring aspect, and then they should
follow that definition. The vague outline for this is that part number
includes a definition (which never fundamentally changes) that nails down
enough to fulfill a certain form fit and function. "Form, fit and function"
could be very loose or very tight, here are some examples:

Loose: Where the part number is a "sales number" that is exposed to your
customers. And the only enduring definition is that it can anything that
nails down attributes that are relevant to customers.

Medium: Nails down form, fit and function for manufacturing purposes.

Tight: Nails down every attribute, including vendor etc.








 




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 05:48 PM.


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