Table design question

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 2 Sep 2002 16:13:39 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7029744A5@lnewton.leeds.lfs.co.uk>

Hi Mike,

oops! - you got me there. I make it more than one. :o)

When you put it as you just did, it does make me look a bit silly - not to worry.

Mind you, I was working on the assumption - obviously wrong - that your problem was with people designing databases where all parts are in one table - whether they be a sub-assembly, an assembly or simply a single part. I didn't think youd want the parent-child links fromsub/assembleis to parts in there as well.

I'd find it very difficult to do that AND have the parent links for any part included in a sub/assembly relate back to the proper sub/assembly - what if, say, a part was used in more than one sub/assembly - say a machine screw.

I think I'll get more sleep, and read through things better in future :o)

Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Mike Sherrill [mailto:MSherrill_at_compuserve.com] Posted At: Monday, September 02, 2002 2:07 PM Posted To: server
Conversation: Table design question
Subject: Re: Table design question

>> Ok. How many tables is that so far?

-- 
Mike Sherrill
Information Management Systems

Received on Mon Sep 02 2002 - 10:13:39 CDT