...
Click on Model menu then select Open and select the .xml file you downloaded in the Pre-requisite step above.
Aisha add a screen shot of the window where ERP.XML file is opened
Click on the Model menu then select Model settings - verify the Model name and data source in the connection string by testing the connection. If successful connection click OK.
Aisha NOTE: the Data Source should be the as follows, these settings use the current columns available as maintained by the Development Team
Data Source=CULPRNSQL08;Initial Catalog=ERP_Dev;Persist Security Info=True;User ID=ERP_AppUser;Password=Grandizergo1
Click on Table menu option and then choose add table(s) by selecting the table(s) you want to add.
...
On the Tables and Links tab, click on the primary table first then click add link and choose the secondary tableAisha add a note to choose Conditions Builder radio option
In the join condition section, choose the type of join (Inner, Outer, Left, Right, etc...) select the type of join you want from the dropdown (see image below)
choose Conditions Builder radio option
Next in the dropdown (see image below) choose the Foreign Key(FK) that is the Primary Key(PK) in the secondary table
...