I am going to explain how to easily get Database Model Diagrams for set of tables you wish to in Axapta.
Here are the steps to do:
Here are the steps to do:
- Create a new Shared project.
- Drag all the tables you need for the datamodel diagram in to your project.
- Click Tools > Reverse Engineer. The Reverse Engineering dialog box displays
- In the dialog box, select ERX ER Data Model.
- Select the project you just created
- In the file name give correct path of windows location where you wish to create the .erx file.
- Click OK.
- Now go to Microsoft Visio
- Click File > New > Software and Database (or Database if you are using Microsoft Office Visio 2003) > Database Model Diagram
- On the Database menu, point to Import, and then click Import Erwin ERX file.
- In the dialog box, click the Browse button, navigate to the location of the .erx file that you generated from the Reverse Engineering tool, select the file, and then click OK.
- You will now see that tables you selected appear in Tables and Views window.
- Drag items from the Table and Views window onto the diagram surface. After you have added a table to the diagram, you can right-click the table in the diagram, and then click Show Related Tables. This will add all the related tables from the Tables and Views window that are not already in the diagram
This is very good postI get lot of help form this site for troubleshootings and error. This is another link where you can get solution for your problem.
ReplyDeletehttp://daynamicsaxaptatutorials.blogspot.com