Calculated but variable value

[musicarteca]

Hi all,

I have to create a field with a default reference calculated value, but this value has to be subjected to modification. The field is a due date of a task based on a starting date of a project in a related table.

I tried with auto-enter calculated value, but it doesn't work, since some of the fields used in the calculations might be empty at the moment that the record is created.

I tried a self-relationship in the task table to try to lookup the calculated value of the due date to be looked up in a date field so it can be modified later, but it doesn't work either.

Any suggestions?

[Wim Decorte]

Seems like you need to work a "set field" into some scripted process for this to work. See if you can put it into a record or layout navigation script...

[musicarteca]

I really don't want a scrip solution. I opted for the "one field on top of the other" solution.