When you go to Manage Database and look at your Relationship Map is this field by any chance connected to another table via a relational link? You get that error when something you did tries to modify the contents of a calculation field. Either you clicked into a calculation field and tried to type in some data or you have a relationship that is creating a similar result.
Try describing what you did in much more detail.
I have two tables, Tasks, and Personnel. They are connected by a join table: Assignments. In Assignments I have foregn keys: TasksID and PersonnelID. As well as trying to list all the tasks done by various Personnel, I am tring to take the calculation field I created in the Personnel layout that merged the first and last name of the person, and link it to the Tasks layout. I am able to set the field up, but it does not link, and of course, as you pointed out, as soon as I try to type in that field I get the error message.
And you should get that error message. If you are going to try changing a name, shouldn't you be typing in the First Name or Last Name fields?
It sounds like the main issue is that you are adding a related name field to a layout that refers to your tasks table and it is blank. Would that be correct? If so, you will need to examine your relationships/table references and the values in your key fields to figure out what's wrong.
(BTW, a "join table" is the label we database geeks use when referring to a table that serves as the "in between" table between two other tables so that we get a many to many relationship.)
Please describe how you are linking Personnel records to Task records. PersonnelID to PersonnelID or something more complex?
Yes I have a many to many relationship between Tasks and Personnel, thus a join table.
"And you should get that error message. If you are going to try changing a name, shouldn't you be typing in the First Name or Last Name fields?"
When I created the equation that is what I did...
"adding a related name field to a layout that refers to your tasks table and it is blank"
OK, I guess I have to say I am lost...sorry my ole brain can't keep up...:-)
"Please describe how you are linking Personnel records to Task records. PersonnelID to PersonnelID or something more complex?"
Hmmm: all I have :
Tasks :: TasksID to Assignments :: TaskID
Assignments :: PersonnelID to Personnel :: PersonneID
Hope that is clear...
Thanks for the help....
Sorry, when you said you had two tables, I missed that the next sentence described a third join table in your earlier posts.
When you created your layout, what table did you specify for it?
Describe step by step how you put your "Name" field on that layout.
I suspect that your many to many relationship is keeping you from editing a related field.
I am off home now, will look at those question in the morning...
I am using the generic layout created by filemaker when I created the table..
I am realizing that I am totally out of my depth here. I am a total newbie to database design, trying to build a 6 table database and getting totally confused. Maybe time to find a consultant, don't want to waste the bosses time...