> Ideally I need several fields (probably 20) to type a book title in with each field having a different title. However, I would like each field to be called "Title." Is this possible?
I think that what you really need is several records of a related table.
How would I go about setting this up?
These may be useful
Database normalization From Wikipedia
White Paper for FMP Novices
To set this up, do the following:
Pull down the File menu and select "Manage -> Database". Click on the Tables tab and add a new table "SubTable" (you can always rename it later). Click the Fields tab and add the field "ID" (Number) and "Title" (Text).
At the top left of the fields, click the drop down next to "Table:" and select your original table. Add a new field "ID" (Number). Click on Options and put a check mark in the option for Serial Number. That is, when each record is added, a new serial number is generated and placed into this field. Click OK.
Click on the Relationships tab, and you will see a graphical representation of your tables. Click the "ID" field in one table and drag it over to the "ID" field in the other table and let go. The "ID" field now appears at the top of the tables with a line connecting them. This means the tables are now related to one another.
On that line, midway between the two tables, is an icon. Double-click the icon and a new dialog appears "Edit Relationship". On one side is the original table, and the other side is the "SubTable" table. At the bottom of the "SubTable" table, click the option to "Allow creation of records in this table via this relationship". Click OK to close this dialog box, and click OK again to return to the database.
Pull down the View menu and select "Layout Mode". This allows you to modify the way data is presented. At the top of the screen, there are a number of tools (represented by icons). Four icons to the right of the oval tool is the portal tool. If you place your cursor over this tool, after a couple of seconds, a description of each tool is displayed. Click the portal tool, as this will allow you to view information from "SubTable". On your Layout, your changes to a plus sign. Click down and drag diagonally to create a box. When you let go, you are prompted for what table you want to display. Select "SubTable". You will then be prompted for fields. Select "Title".
Go to Browse mode, add a new record, and you will notice there is "1" in the ID field. In your portal, there is a place to enter a Title. Enter a title, and then you can enter another one beneath it. Continue for as many as you need.
Add another new record, and ID now equals 2. Add a couple of Titles there, too.
If you skip back to the previous record, you will see the related set of titles that you entered previously.
This should get you pointed in the right direction. Let me know if you need clarification for any of the above steps.