Simple single level Bill of Materials
We are new to Filemaker and are trying to set up a very simple Bill of Materials...we are well aware of how complicated this subject can get, but we only need something very simple. We have set up two tables, one for Completed units and one for Components linked via a third as can be seen in the screen shot.
All we need is to create a completed unit record, then by viewing the parts list attach the components that are required to complete the unit...nothing more.
The end result being that we could search for a completed unit and see on screen a list of the parts required to produce it. We can see how to achieve the end result using a portal...but how do we set up a "routine" to select and add the parts to the completed unit in the first place.
Aa I said above we are new to Fillemaker and most likely don't fully understand it.