To give a precise answer you would need to see the structure of the database. However, generally all you need to do is insert a button and use its click event to write the following code:
Private sub cmdOpenFile_Click()
On Error GoTo Error_cmdOpenFile
Application.FollowHyperlink "full...
The result of an experiment is in the tblExperiments table (ResultConclusion field) and not, as you reported, in the tblExperimentIngredients table.
If the quantity of an Ingredient changes, it is a new experiment.
What you should see is the data in the mode exposed in post #11 but concerning a single Order with all the other data linked to it in order to see a real situation from start to finish and therefore be able to understand better.
To actually understand how to handle it you should show the one seen in post #11 for a single order so you can see the progress of the process starting from the order to the sale.
This is because it seems that there are some inconsistencies to see
in the Material Information table->Material...