Thank you for your post.
Pull down the File menu and select "Manage -> Database...". Click on the Relationships tab, and you will see a graphical representation of your Sheet Music Library table and Composer table. Make sure that "Composer ID" field is present in both tables, because we will want to link the two tables together via this field. Once linked, double-click the icon that is halfway between the two tables. On one side will have information from the Sheet Music Library table, and the other side will have information from the Composer table. On the Composer table side, near the bottom, be sure to check the option "Allow creation of records in this table via this relationship". Click OK.
Now, go to the layout that displays your Sheet Music Library table, and create a portal into the Composer table. Include the fields Full Name, First Name and Last Name.
Double-click on the Full Name field and a "Field/Control Setup" dialog box appears. Change the "Display as:" pop-up to show "Drop-down list"
Just below that, "Display values from", select "Manage Value Lists..." and another dialog box appears.
Click "New..." and another dialog box appears.
Enter the name "Full Name", and select the option "Use values from field...". Another dialog box appears.
Under "Use values from first field", select the Composer table, and then select the "Full Name" field. Click OK a few times.
Go into Browse mode, and you will be able to click on the Full Name field, and a list of composers will appear. Type the first couple of letters to move you down the list to the appropriate entry, where you can then select the Composer. If a composer isn't listed, then you can add the First Name and Last Name in the appropriate area.
This also allows you to enter two or more records for composers. For example, John Lennon and Paul McCartney.
This should give you a good starting point. If you need clarification for any of the above steps, please let me know.
Thanks a lot, your instructions worked very well. I can see that relationships provide a much more powerful database.
Just one problem appears:
When a use the drop-down list (that's working) to select a composer name in a new sheet music record, I receive the following message: "This action cannot be performed because this field is not modifiable". It's impossible to select an item.
Do you know what's happening and how to fix this? Maybe I made any mistake…
Thanks so much, and congratulations, FileMaker is incredible.