I have a table named WellDocuments with a WellID, DocumentTypeID and WellDocument fields.
I have another table named DocumentTypes with a DocumentTypeID, DocumentType and SortOrder fields.
The tables are related using the DocumentTypeID field.
I am trying to add a calculated field, SortOrder, to the WellDocuments table to lookup the SortOrder from the DocumentTypes table.
My formula is: =Related('DocumentTypes'[SortOrder])
I get the message: Error validating the formula for column 'SortOrder'.