I am trying to work out how Sage/Report Designer link the data between the actual Sage tables and the transient tables that report designer uses. We print out some stock labels and the report uses a Stock_Label_5559 table for its data which is made up of fields from other tables in the sage database, but how does it know which fields to use and how to link them? Is there anyway to change them or add to them? 

Just trying to work out how it works.