I don't even know if this is possible....

We have a schedule module that lists the development times and details of the product. This module contains a code field which is relevant to the specific product and version of the product.

We also have an order module where agents can select the product and select the version and raise customer orders.

What we need is when the agent selects product1 from a dropdown and version 3 from a dropdown for the order module to look at the schedule module, see which product it is, see which version it is and select the correct code related to product1v3.

Now this is where it gets interesting, the order module can contain more than one product, or have one product but multiple differing versions which would also need to be populated.

Is this possible?