How To create Table Relation Lookup in D365fo

 How to Create Table Relation Lookup in D365fo

Setup A Relation

Open your primary table in Visual Studio. In my example, my table is named ‘rsmVehicle’.

Select the ‘Relations’ node. Right click on the relations node and select New>Relation.


Next, right click on the node, in my case named ‘rsmModel’, and select New>Normal.


Finally, in my example I repeated these steps for the rsmMake relation to specify a relationship between the MakeID field on the rsmVehicle table and the MakeID field on the rsmMake table. The end result looks like this.


Finally, we can see what this looks like when we click the drop-down in the Vehicle form.




Location: Karachi, Karachi City, Sindh, Pakistan

Comments

Post a Comment

Popular posts from this blog

How to remove deployed model in Tier2 environment in D365FO

 How to remove deployed model in Tier2 environment Dear all, I have an issue with the deployed model in the D365FO Tier2 environment. I have some models in the development environment: Model A Model B Model C Model D I want to apply only Models A, B, and C for the Tier2 environment, For the first time for deployment, I created a deploy package(including Model A, B, and C) in development and applied an update for the Tier 2 environment. However, yesterday, developer X on my team deployed a new deployment package(Model A,B,C,D). So today I could not deploy the package in Tier 2 with Models A, B, and C. Solutions: 1. Download the same package from Asset Library which was previously deployed. Add File ModuleToRemove.txt (with model listed). Reupload to Asset Library and deploy to UAT. When I do this,  there's a warning on LCS that "it will first reinstall the model and then delete it. In order to not reinstall, delete the model from package." 2. Create a new package (on dev m...
Read more

how to connect Just in time DB in D365F&O / Connect UAT Database with Dev machine in D365 F&O

Image
 Connect UAT with the Dev Environment Step 1: Go to LCS and select your UAT/ Tier 2 Environment  Path: Click on your Project Name from the Top of the LCS screen. Select your Environment full detail page Step 2: you should have to enable access for you VM to connect UAT DB. Click on Maintain -> Enable access Now Modify firewall rules form is open. Click on Plus button to add your VM ip address. Now go to your VM and find your ip address by just checking on chrome with "what is my ip" put your ipv4 ip address in the last open form " Add an Inbound Allow rule " in LCS put anything in the Name field and select Confirm. Now, you will get a popup from LCS. Step 3: Go to Database accounts table  field : Reason for access select Performance tuning for AX (Write to AX) field : Details put any comment Click on Request Access Refresh your page and you can see the DB detail on the " DATABASE ACCOUNTS" Tab copy all 4 keys to any notepad++ for clear readability. How...
Read more

How to Create Auto Lookup Using EDT with Table Reference in D365 F&O

Image
  How to create a lookup in D365FO using X++? Lookups are the standard way to display a list of possible selection values to the user. For a user, while editing or creating database records, a lookup makes the data entry easy and errorless. In Microsoft dynamics 365 finance and operations, there are many ways of creating lookups. EDT and Table Relation Type lookups are the simplest forms of lookups in Microsoft dynamics 365 finance and operations. In this article, I will describe the very simplest type of lookup, which is EDT lookup, for making an EDT type lookup, a developer does not need to worry more about writing x++ coding,   Normally, standard lookups are created automatically by the system in Dynamics 365 for Finance and Operations and are based on the extended data types and table setup.  They are based on table relations and appear automatically. No additional modifications are required. Setting Up an EDT Lookup If you are a beginner use  Microsoft's free ...
Read more