Editable Grid with one to many relationships

Question

I have my own data or CDT called "Clients" and i have a relationship with other CDT called "Vendor"
I have this editable grid created with the CDT called "Clients" (red square image bellow) this works great.
Now i want add the related data or relationship of the CDT called "Vendor" (blue square image bellow) into the editable grid 
Its possible?
How do I call that data?, what expression should I use?

Here is my relationships between my data

deepakg681722 · Answer

you have two approaches here.

1) You can create a view and use that view to show the editable grid.

2) You can query the data from the record type instead of calling it by queryEntity. while displaying record data into interface it will show you the relationship as well to show the related record data.

As i see in the images, your relationship is one-to-many so according to the requirement you can made the logic to display the expected data.

Sign up

Login with SSO

Login to the community

Login with SSO