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.