1 Reply Latest reply on Sep 4, 2013 4:30 PM by philmodjunk

    TO for external table



      TO for external table



           I have an external table with a Field called Type ( this will be used in other files )

           Next, in the local file, I have a global field called gType, which is just a fixed string

           On the relation graph I link gType to Type of the external table

           Then create a layout linked to the external table. And what I expect is all records from the external table that have a Type equal to gType. But what I get is all records from the external table, as if there is no link. It sounds easy enough. I know I can duplicate this through a find, but I figure a TO would be faster and easier to maintain. 

           Any ideas?

        • 1. Re: TO for external table

               This is true for any table occurrence whether they reference a local or external data source.

               You appear to have this relationship:

               LocalTable::gType = ExternalTable::Type

               and you then set up a layout that lists ExternalTable in Show Records From on Layout Setup. In such case, the relationship from LocalTable to ExternalTable has no effect on the records accessible in External Table. You have two options:

               1) Create a layout based on LocalTable with a portal to ExternalTable on it. Then the relationship you have specified will work to list the related records from the external table.

               2) Keep the layout based on ExternalTable and perform a find for records that have the type specified in gType. This can be scripted and performed by the onLayoutEnter script trigger so that the user only sees the records for the specified type when they enter the layout.