Limiting value lists to one value

[Jarvis]

I have a database with two fields.

Field One = ANIMAL

Field Two = FAVORITE FOOD

Both fields are populated via value lists which draw their values from the respective fields.

The second field, FAVORITE FOOD is constrained to using only related values from the first field.

IF: ANIMAL = Bird > FAVORITE FOOD = Birdseed

IF: ANIMAL = Dog > FAVORITE FOOD = Kibbel

This is pretty simple so far. When you select the animal name, a list of possible food presents itself for you to select from.

What I would like is to have the value for FAVORITE FOOD automatically selected as a default choice

(Not as an option to pick from) so that when you click on Dog, Kibbels shows up immediately.

This would probably require that the value list be constrained to just one value but I still need to have the ability to override this value.

Can this be done?

Thanks,

Jarvis

[The Shadow]

Make the Favorite Food field an auto-enter Lookup and it will fill in with the first related food.

You can then still change it with the value list.

[Jarvis]

Shadow,

Thanks. That is just what I needed.

Jarvis