value selection dependant on previous value

[stretch]

I have two 30 item value lists in the same database for fields called "product code" and "variety". The product code is just an abbreviation of the variety and is unique to each variety (i.e. RB is equal to Russet Burbank). When I enter a product code, I would like to have the corresponding variety auto-enter in the Variety field. Is there any way to accomplish this?

[Fitch]

This is easy to do using a separate file for your codes and varieties. Are you familiar with lookups?

[stretch]

I thought that I was, however I am running into a brick wall with this. Do I need to create a seperate database file?

[Fitch]

Create a separate file that contains the product code and variety fields. Create a new record for each product. Now in your original db, make the variety field a lookup based on the product code. Also, you can make the value lists in that file based on the contents of your new file; that way you don't have to worry about keeping the value lists in sync.

[stretch]

Will go that route. Thanks Tom!!!