There needs to be a way for developers to handle cross company table relations within a data entity. There are two scenarios that developers should be able to handle:

1. A join between tables with no consideration of dataareaid
   
   
   
   1. For example, we have a RecId reference in a table and want to join on just that recid.
   
   
   
   


2. A join between tables using a dataarea reference
   
   
   
   1. For example, using the ProjectDataAreaId field in TSTimeSheetLine table to join to the ProjTable
      
      
      
      1. Currently we can define this relation, but when the database is synced it includes TSTimeSheetLine.DataAreaId = ProjTable.DataAreaId.
      
      
      
      
   
   
   
   

This feature should also support change tracking.