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.
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.