Add a calculated column that references a field in another table. You’ll notice that the formula uses the RELATED function to reference the table that isn’t in the active table, Sales.

Driver-specific informational message. (Function returns SQL_SUCCESS_WITH_INFO.) 01004: String data, right truncated: The buffer *ColumnName was not large enough to return the entire column name, so ...