>Thanks John,
>
>That's what I've been doing so far, unfortunately a lot will have to do with trial and error. I can make it work for this particular company no problem but wanted to make sure to do it the "right" way following inventory guidelines so it could work for other type of companies too.

Roy,
you are welcome. I just thought of one more thing. You might want to check the library of the biggest collage/university in your area. Usually you can enter and read the books, but of course, not take them out. That is the only place I have ever found books with the depth you will need.