Hi there,
Any chance that there is support for using data from te main form and patch that to selected items in the subgrid?
The scenario is that I have a table (subscriptions) with a subgrid embedded with all the active contacts, therefore I want to create a subscriber record. I use the method which Scott Durow posted for updating multiple items in the subgrid;
ForAll(Self.Selected.AllItems As Thisrecord, Patch('Subscribers',Defaults('Subscribers'),{Contact: Thisrecord,',Subscription:LookUp(Subscriptions,Subscription=GUID(Subscription))}));
The script above work perfect in a way that it create the subscription records, however it always links to the first subscription in the table. Basically what I want to achieve is that the Subscription marked in red, is being filled with the GUID from the main form. Any chance this is possible with PowerFX commands?


Report
All responses (
Answers (