Can't use script triggers with IWP. Committing the record is the only way to submit the data back to the host and get the related data returned as far as I know.
As always, Thanks for responding Phil.
Without using a script trigger, Is there a technique I can use that
1. after the user hits the tab key out of the 1st field, the record is submitted AND
2. the validation is ignored so that the related data is displayed
The only method I can think of would be this script:
Set Error capture [on]
Commit Records [skip data entry validation]
But IWP users would have to click a button to perform that script...
That's what I had for a script trigger once the user tabbed out of the key field.
I guess I could create a button that has VERIFY INFORMATION, but in reality it performs the commit record and skip validation. :)
But once they click on the SUBMIT button it will try to commit and NOT skip validation.
Thanks very much Phil :)
You might put the fields from the related table inside a tab panel. A button can take the place of the tab label and then the users click the button to reveal the fields from the related table--submitting the data without realizing that they have done so.
I didn't know Tab panels could be used in IWP.
I'll give it a shot.