Hello! So say I have the following tables/columns:
'Team.Team Id'
'Team.Name'
'Team Member.Team Id'
I have a primary "team" dropdown that I've set to show the team name. Then I have a connected "team member" form, and I want it to have a dropdown that defaults to the 'Team Id' column (property) of the "team" dropdown's selected.
I've tried as the default of my "team member" dropdown:
Team_DropDown.Selected.'Team Id'.Value ("Invalid use of '.'.")
Team_DropDown.Selected.'Team Id' ("Expected Record value.")
Value(Team_DropDown.Selected.'Team Id') ("Expected Record value.")
Any ideas?
(As an aside, is there a way for me to inspect an entity like Team_DropDown.Selected.'Team Id' to find its data type, members/properties etc. like I can in a web browser developer console??)
