Hello I am writing a DB to track chemical usage on fields of crops grown on my farm.
It has evolved over time and is becoming more complex.
If I explain that I have a recommendation table (Rec) that relates to a mix table and I want to apply these chemicals to a group of fields (application table).
What I want to achieve is putting the 4 chemicals on each field (EH7 and AV1) and later displaying all the chemicals displayed on any given field.
The Mix ID should be the same for each field but as you can see it is not.
I have no doubt that the problem lies in the relationships between the portals/tables .