Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 3802 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

  • Newbies
Posted

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 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.