From this point on we have all we need for everyday tracking of the item within the one table shown below.

The type of crop, and so its compatibility, can be coded into it's ID number. this would allow you to carry the necessary data to detect potential blending difficulties at remote sites without the need to be connected to the Internet or carry a copy of a large and cumbersome amount of data.

The information on the component parts of a crop are always available from an Internet connection by simply querying the main database using the Contract ID No.