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

[Gurgle Moo]

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.

[Fenton]

Method 1:

Look at the option in a value list for "Show values only from the 2nd field."

The "code" is the 1st field, the "name" is the 2nd field.

Use a "pop-up menu" as the type of value list on the layout.

It looks like the Product name, in both Browse and Find modes, but it's really the Product Code field.

The "name" field must be unique within its table (or only within that filter? don't know).

Method 2:

Similar to above, field is the "code", 2nd field is "name". But do not check "Show only 2nd field."

Both the code and name will show in the value list.

The value list on the layout could be "drop-down list"

Put both fields on the layout. The "name" will be only be enterable in Find mode. It can be on top of the code field, offset so you can see both.

The "name" field can be either just a related field, or can be a Look Up (or auto-enter by calculation, with Replace) of the name field from Products, depending on how (and how fast) you want to use it in Finds and reports.

Method 3:

Enter in either, auto-enter by calculation the other. This can be done (?). But I don't recommend it. It is tricky and I don't think necessary.