Set field to dropdown and specify values to display

ckinninger

Registered User.
Local time
Today, 09:49
Joined
Mar 29, 2011
Messages
12
My mind is blocked even thought this would seem pretty simple...

The form shows one record at a time of a Query. The Query is made up of two tables where EyeColorID fields intersect.

In the form I don't want to show the EyeColorID (1,2,3) from either table. I just want to pick from the colors (Green, Brown, Etc...) using a drop down.

Basically the dropdown selection would change the personTable EyeColorID field value based on the color I selected. The colors are from the second column in the EyeColorTable

Great forum.

Thanks for your help.
 

Users who are viewing this thread

Back
Top Bottom