AnsweredAssumed Answered

Need help with Drop down Box lookup from related table

Question asked by MarkWilkins on Aug 15, 2012
Latest reply on Aug 15, 2012 by philmodjunk

Title

Need help with Drop down Box lookup from related table

Post

I'm new to Filemaker Pro - been an Access user for years.  I have two tables - one "Booklets" with an autonumber BookletID for key field that includes as one of its fields "AuthorID".  The other table is "Author" with AuthorID as the key field and AuthorName as a text field.  I have related the two tables by AuthorID with a one to many from Author to Booklets.  I was wanting to create a dropdown box for the Booklets Table that shows the Author name but actually stores the AuthorID from the "Author" table as a lookup.  How is this accomplished?

Outcomes