AnsweredAssumed Answered

packaging material breakdown

Question asked by wcambris on May 3, 2018
Latest reply on May 4, 2018 by ThierryGuemboura

Dear Gents

As I am trying to move into filmmaker, I am trying to make a solution that covers the following:

1- I have a list of raw material used in building different items called "package".

2- Each package can be made of one or many raw material as well as it can incorporates other defined packages

3- When I place (for example) a procurement request, I can list the packages and or raw material needed to fulfill the task.

5- Once the entry is done, I want the procurement detail to show the breakdown to the least level (raw material) needed to fulfill the task.


I have attached a small example to clarify my problem (the example doesn't show the usage of packages within packages).


Can anyone help on specifying in details how this should be done, ERD and scripting ( as I mentioned earlier, I'm trying to move to FileMaker).

Thanking you in advance.


Screen Shot 2018-05-03 at 8.26.52 PM.png.