Aliases and Lookups

[Rick Hane]

Interesting problem...  I am trying set the usage for my mfg.  To do this I 
have a sales file (psch), bill of material file (bom) and a usage file 
(use).  Basically, items in the sales file lookup their respective bill, 
determine the usage factor (qty used per part) and write that usage to the 
use file.  So far no problem.

Now the interesting part... each bill of material may contain up to 125 
parts many of which are also mfg and have their own bills of material.  In 
fact this may run out to 5 levels deep.  I can set up nested gosubs doing 
lookups to the bom file and use an alias for each lookup; however if I 
remember correctly the minute I open another lookup to the same file (even 
though it has a unique alias) I will move the pointer in the previous lookup 
to that same file.

First, is my statement above correct and I loose the pointer?  If not then 
no problem.  If it is correct, anyone have thoughts on how to do this 
without setting up and complete levelized bom file for each part?

Thank you,
Rick Hane
Yore Software
Email: yoresoft at hotmail.com
Deluxe Stitcher Company Inc.
Url:www.deluxestitcher.com
Email: rhane at deluxestitcher.com