Using Portal to display tasks on Employee form. A script finds Open or All Tasks using a Relationship between global and calculation fields. Works fine.

However, CANNOT Add new Record from Portal -- error "This action cannot be performed because this field is not modifiable" -- even though a = Relationship is set up between EmplID fields & Allow Creation enabled.

Both Relationships discussed above are defined in a single Relationship link.

Research on this Forum indicates it's the relationship of the Global and Calculation field -- didn't understand it entirely -- I guess because the Calculation is a concatenated value that is not = to the Global field. I removed that link and added records through the Portal. But now the Script doesn't return the FoundSet.

I need to do both. I tried creating a Self Join so each matched field could have its own relationship, but that didn't work. I'm at a loss of how to change the Relationships so I can accomplish both tasks (pun). Please help....

ToDo_Tasks.zip

When you use the function to create a new record via a portal through a relationship, what happens is that filemaker actually creates a record and then "types" in the foreign key to make the connection. But in your case, the foreign key is a calc, so FMP can not type into it.

So the the answer is the "create related records" will never work if the distal key is a calculation.

The work around is to change your relationship to not use a calculation or to create a simple script attached to a plus button that creates a new remote record by filling in the various fields that comprise the calculation.

Hope this Helps