Getting a value from a related DB
Instead of displaying a filed from a related table, I would like to get the value of that field at the time of the record creation to a field in the main table. How do I do this?
I tried the following and it does not work:
- Used a calculated field
- Set it equal to the related field
- Tried to uncheck the "Do not store claculation results--recalculate when needed"
I get "The calculation "field_name" cannot be stored or indexed because it references a related field, a summary field, an unstored calculation field, or a field with global storage."