Newbies Rankoor Posted August 23, 2014 Newbies Posted August 23, 2014 I have a Bill of material (BOM) structure with 2 files: File A which contains all items (Finished products, Semi finished products and purchased items), and the fields are item-number, item-name and various descriptions File B is related to file A by Father number = Item-number and contains item-number, item-name as the A file. File B i populated via a portal where the user selects from File A items and specify quantities. A Finished or semi-finished production can therefore be comprised of a tree structure of items: O ------ S --------- S -------- i l l l l -------- S l l ------- i l l ------- i l------------ i The component structure can be up to 10 or 12 levels deep depending on the complexity of the item. Any given Semi finished or purchased item can be part of a number of build items For any Finished/Semi finished products (0) i would like to be able to print a BOM list with all the sub items sorted as the above structure implies. But i have trouble with identifying the items in file B which are related to the (o) item as child, grandchild, greath-grand child etc. I have tried scripted loops and levels of relationships but have not found a god way to solve the problem. Ideas/solutions will be highly appreciated.
No_access Posted August 25, 2014 Posted August 25, 2014 Have you looked at the thread below. this seems to be similar to what you are asking. http://fmforums.com/forum/topic/30125-bom-database/
Newbies Rankoor Posted August 26, 2014 Author Newbies Posted August 26, 2014 Yes i have looked at that thread - but the topic is very different. My problem is very specific and more related to Filemaker technical areas than to general BOM problems. But thanks
Recommended Posts
This topic is 3802 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now