New Row in Portal from Relationship using Calculation Field

[Stephen Fleming]

So I have a portal to another database; the two are joined by a relationship that is a calculation field on both sides.  I have "allow creation" checked, but typing into the empty bottom row to create a new record throws the error "This action cannot be performed because this field is not modifiable."

 

That actually makes sense, but I have no idea how to get around it. Suggestions? Thanks.

[eos]

You could script the process of creating another record in the second table and setting the fields on which the calculation is based (this also lets you get rid of the spare row at the portal's end). On the other hand, instead of matching the calculations, you could match the fields on which the calculations are based.

 

Let me add that relationships in which the key on both side is a calculation normally wouldn't be one via which you create child records directly. What tables are you relating to each other?

[Stephen Fleming]

I'm linking a list of daily journal entries to an external database that contains birthdays, anniversaries, and other annual events.  The relationship is based on a calculated field MonthAndDay which is set equal

 

(DayOfYear ( IndexNum )*100) + Day ( IndexNum )

 

where IndexNum is a Date stored as Number.  There can be multiple birthdays on the same date, which is why I use a scrolling portal to show them.  The problem is when I want to create a new birthday entry from the main database, but I can't create a new MonthAndDay.

 

I've accomplished what I needed with scripting (good suggestion) but it means a separate layout for data entry, and retyping the Month and Day values individually. I can't use the blank portal row, which I'd actually prefer.  Thanks, though!