AnsweredAssumed Answered

creating dropdowns with values from related tables

Question asked by janpoppe on Oct 12, 2011
Latest reply on Oct 12, 2011 by philmodjunk


creating dropdowns with values from related tables


FileMaker Pro

Operating system version

mac os

Description of the issue

Could someone instruct me on this?
I have following situation as an example:

Table :members
Name, string
Address, string
Gender, number

Table :genders
ID Gender: number
GenderNam: string

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.