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?