We have a FMP solution with a table built just for an ODBC connection. It has a primary key field and all other fields are calculations pulling data from various tables and in the case of a couple fields, from another table that is in another physical file. Do we need to create a DNS to the other file if we're not accessing it directly, only 'indirectly' thru the calculated fields? We're having trouble with 2 fields returning NULL values. The priv. set is defined as View only in all tables. Thx in advance for any addl. info.