Need help with Drop down Box lookup from related table
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?