Auto Fill with Override

[ejpvi]

Greetings,

I have some ideas on how to do this, but I wanted to hear what others have done to accomplish this.

I normally use Calculated fields to just have the data show up from a related table. One-to-many relationship usually.

Recently, someone asked me to make it possible for him to Override the field if he wanted to.

I wasn't sure how to proceed....

A calculated field, will always stay in sync with its related data... The only way I can think of producing this override feature would require it to be an "auto-fill" text field.

If I were to change it to an "auto-fill" field it just fills in once, so if the other table was updated I would never see the change.

Anyone have a nice way make this work?

Where data stays in sync with the related data, unless overridden by the user?

[comment]

You don't need a calculation field to show data from a related table - you can simply place the field from the related table on the layout.

To override, you need a field for the overriding value and a calculation field to choose what to display, e.g. =

Case ( IsEmpty ( Override ) ; Related::Field ; Override )

Or just use conditional formatting to show/hide the appropriate value.