Auto select value in dropdown list based on selection of another dropdown

[Gurgle]

Hi,

 

I am an FP ubernoob and trying to set up a stock management system for a warehouse with FP9 but am running into a bit of a nuissance regarding a pair of dropdowns.

 

The drop downs contain a 'Product Name' field and a 'Product Code' field.

 

What I am aiming to do is to choose a Product Name from the drop down, and the matching Product Code would automatically be selected and vice versa.

This way, either field can be used and the other automatically is updated to match.

 

Both drop downs using related valuelists based on a records in a 'Product Range' table.

 

Gurgle.