creating dropdowns with values from related tables
Operating system version
Description of the issue
Could someone instruct me on this?
I have following situation as an example:
ID Gender: number
When editing People records, I want a dropdown which lists the fields Gendername from the genders table. Upon selection the ID_Gender has to be stored in the Gender field of the people table. (I want a number stored in the people record and not a string)
Very frustrating for knowing this is not an issue at all in VB or Microsoft Access.
Thanx for help.