Db has forms with names:
frmInputPlants
tblInputProducts
tblProductConstituentDetail Subform
Only the first one works.
My initial inclination would be to have a structure that relates Constituents to Product and Products to Plant. But you have a requirement to differentiate Constituent requirements by the source Plant. Gets complicated. Looks like you have a handle on that.