Hi,

Buy yourself a copy of the book "Practical Issues in Database Management" -
it has a very good example and "how to" for this - amongst many other good
things to say about db management.

It's written by Fabian Pascal - see www.dbdebunk.com


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Hi all...
>
> I just need a second opinion on something
>
> As part of a new app I have to implement a multi-level Bill-of Materials
> and am pondering the table structure to use
>
> ie - top level is level 1, parts that make it up are level2, if any of

these

> are sub-assemblies - level 3 ?? etc
>
> I am sure this has been done loads of times - it is how to cope with
> multi-level
> sub assemblies I need input from
>
>
> Regards
>
>
> Roger P
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>