AnsweredAssumed Answered

ODBC connections to multiple files

Question asked by KathleenBrown on Oct 1, 2015
Latest reply on Oct 5, 2015 by KathleenBrown

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.

Outcomes