This sounds like your calculation field specifies a Number Result Type in the Specify Calculation dialog.
Try changing your calculation type from "number" to "text".
I tried this and it worked:
First Name & " " & Last Name & " (" & GetAsText(Year of Birth ) & " - " & Year of Death & ")"
Many thanks for these ideas.
GetAsText didn't make any difference, I'm sorry to say.
However, the suggestions about calculation type got me thinking. I had checked previously that the type was set to text, but I have several instances of the table in my database. Apparently you can alter these individually. I never knew that. Going back to the correct relationship, allowed me to see that the type was indeed set to number in the table that was referenced in the relationship.
I am at the limits of my FMP knowledge here, and must confess that I've never really made the transition from flat-file to relational with what I feel is a sufficient working knowledge. In other words, I kludge things, until they work, sort of. So, apologies if I'm not explaining very well.
Thanks for your help. Problem solved.
I am at the limits of my FMP knowledge here, and must confess that I've never really made the transition from flat-file to relational with what I feel is a sufficient working knowledge.
but I have several instances of the table in my database.
"Instances" is a slippery term here that might refer to having several "boxes" on your relationship graph that all refer to the same table or it may mean that you save several separate copies of your table. It would appear you have several completely separate copies of the same table given the change to a specify calculation dialog that you've described. That's a potentially serious design issue with your database.
Thanks, PhilModJunk - that's good advice. I thought I had separate boxes, but you are right that it looks like I might have separate copies. I'll go through the database, and look at that.
For any given table occurrence (box in Manage | Database | Relationships), you can hover the mouse over the top left hand corner and see the name of its data source table pop up.
And when you click on the Tables tab, the data source tables defined in your file are listed on the left, and the table occurrences that refer to them are in a comma separated list to the right of them in the column labeled "Occurrences in Graph".