AnsweredAssumed Answered

Creating dropdown lists from a child table

Question asked by RachelG on Feb 16, 2012
Latest reply on Feb 17, 2012 by philmodjunk


Creating dropdown lists from a child table



I am very new to Filemaker.  I am using 10.0v3.  I am not as new to relational database design. 

I have two tables- an Organization table and a Religions table. Each organization can only be associated with one religion. I set my religions up in a separate table because I may use this table for other relationships as the project expands. Each religion has a Religion_ID_pk that I have as a fk in my org table.

In the data entry screen I would like the list of religions from my religions table to appear as a drop down for a user to select from and then have the org table store the associated Religion_ID assigned that religion. I am having trouble with this.  Could anyone lend some insight?