[AccessD] OT: The Great Primary Debate

jwcolby jwcolby at colbyconsulting.com
Fri Jun 11 10:33:58 CDT 2004


Charlotte, that may or may not be true, but that is just an example.  Take
the next size up, a carburetor.  You might want to serialize a carburetor
for service purposes.  Nothing different between it and the next (identical)
carburetor, but it still gets a serial number.

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, June 11, 2004 11:10 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: The Great Primary Debate


Well, what *is* distinct about a screw from the same lot?  This is probably
a poor example for this discussion because screws of the same size, etc.,
are interchangeable.  There is no need to identify any particular screw from
a batch of duplicate screws, so it has no unique key!

Charlotte Foust

-----Original Message-----
From: Scott Marcus [mailto:marcus at tsstech.com] 
Sent: Friday, June 11, 2004 5:38 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: The Great Primary Debate


Stuart,

It was just an example. I worked for GE Aircraft Engines for 2 years. I
wrote systems that tracked those screws/nuts/bolts etc. They want to know
everything about anything in an engine. They do not however track below a
lot number on those common parts. You could find anything you needed to know
about a 'lot' of screws but a particular screw from that lot was no
different than any other screw in that lot.

Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com
(513) 772-7000

 -----Original Message-----
From: 	accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]  On Behalf Of Stuart McLachlan
Sent:	Friday, June 11, 2004 9:27 AM
To:	Access Developers discussion and problem solving
Subject:	RE: [AccessD] OT: The Great Primary Debate

On 11 Jun 2004 at 8:28, Scott Marcus wrote:

> John,
> 
> If you have a bin full of 20,000 screws (all the same, because that's
> what I was saying) you would be an amazing person if I could pick up 
> anyone of them, show it to you, take it back, put it back in the bin, 
> mix the bin up, and you could find that same exact screw.
> 

You've obviously never developed any systems for the aircraft industry.

You need to track what supplier and manufacture batch any individual
screw came 
from, what aircraft it ended up on and where. You just don't dump 20,000
screws 
in a bin. :-(









 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list