Re: Product Structure SQL

Tom,

It's not simple, but we have written something that will do this.  We
needed it for our NAFTA certification.  I am not physically at work today
(remote from home), but if you e-mail me directly on Friday, I can send you
how we did it.

Dale Gindlesperger
IT Manager
Fleetwood Folding Trailers, Inc.
dgindles@fft-inc.com



                                                                                
                                
                      "Tom Wood"                                                
                                
                      <TomW@fortrecoveryindu        To:       
<mapics-l@midrange.com>                           
                      stries.com>                   cc:       Shawn Thobe 
<ShawnT@fortrecoveryindustries.com>   
                      Sent by:                      Subject:  Product Structure 
SQL                             
                      mapics-l-bounces@midra                                    
                                
                      nge.com                                                   
                                
                                                                                
                                
                                                                                
                                
                      01/23/03 02:40 PM                                         
                                
                      Please respond to                                         
                                
                      MAPICS ERP System                                         
                                
                      Discussion                                                
                                
                                                                                
                                
                                                                                
                                




Hello All,



Anyone have a  pc app (excel or access) that uses ODBC, etc. and has  a
SQL query that successfully will produce an indented bill of material?
We're working on a little project where we want to throw the BOM into
Access or Excel and can't seem to put together the proper joins to
accomplish this.  Probably something simple. Any hints, examples, etc.
appreciated.



Thanks,



Tom Wood

Fort Recovery Industries Inc.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.