Re: Bill of materials explosion report

[Chris Snow <chris_snow@EMAIL.MSN.COM>]

Sounds like you're looking for a report that details the hierarchy
relationship in an "Item Assembly Structure" where an equipment or location
or building (etc.) record has a list of parts, each one having a list of
related materials and each of those materials having a related subassembly,
etc.

What kind of records are you accessing?  Equipment lists?  Inventory
subassemblies?  Can you provide a table layout of source data and some kind
of schema for the required output?

________________________________________
Christopher Snow, Integrity Information Services
800-724-5939 pgr
chris_snow@msn.com
'As knowledge increases, wonder deepens'
                                       Charles Morgan



-----Original Message-----
From: SEMECH <jstein@MAIL.NETVISION.NET.IL>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Monday, March 09, 1998 9:30 AM
Subject: Re: Bill of materials explosion report


It may be bad translation.

What we are looking for is an SQR report that lists all bill of materials
data in the
right hierarchy order.

Yoav
-------------------------------------------------------------------
SEMECH SOFTWARE MARKETING LTD.
TEL : (972) - 3 - 5333144
FAX : (972) - 3 - 5333132
Email: <semech@pobox.com>
------------------------------------------------------------------