You can define a relationship between two tables if any of the fields in one of the secondary table’s keys are also present in the primary table. The fields the relationship can be based on don’t need to be part of a key in the primary table, nor do they have to use the same global field. However, they must be based on compatible data types.
For example, a relationship could be defined between the Sales table and the Customer List table, based upon the Buyer Name field in the Sales table and the Customer Name field in the Customer List table.
If a report you’re creating needs information from multiple tables, table relationships must exist that indicate how the data in each table relates to data in the other tables. The most-common table relationships have already been set up in Microsoft Dynamics GP. If a table relationship hasn’t been defined for the table you need to access, you will need to create one using the information provided here.