
Announcements
Good morning. I have two tables that I'm trying to create a N:N relationship using a junction table. I've chosen this route because I need to add additional meta data on the relationship. Table 1 is the User table, Table 2 is the Team table. The additional meta data is team role. The junction table name is Team_Members.
I have a 1:N relationship setup between Employee and Team_Members
I have a 1:N relationship setup between Team and Team_Members
I have a 1:N relationship setup between Team_Role and Team_Members
In the app, I have a gallery configured to display a list of all employees that are in the Employee table. I have an icon that when clicked opens an edit form with the Team_Members table as the source. I'm trying to get the Employee drop down to populate with the name of the employee from the gallery. Then the user would select the team and role for the user and save it.
Is this possible? Thanks in advance.
I have Select(Parent) setup on the button. I thought that I could limit the item list using that but that's where I am stuck.
Hi @sbarbarino ,
On Select of Icon in Employee Gallery write below code to set the global variable
Set(selectedAccount,BrowseGallery1.Selected);
Now on Team member Employee Dropdown DefaultSelectedItems property set the above variable
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/