I’ve been pounded many a times by guys asking how to use Power forms. There have been not much tutorials on using Power forms, and its benefits. So I thought of writing up a simple Power Form usage, and a basic tutorial/guide to help all of us.
Lemme try to summarize Power Form System Functions and Event Rules. I’ll also try to make use of Saved Query Controls. I assume that you have basic JD Edwards Technical Skills and knowledge to accomplish this.
Following are the activities which I’m going to do in this example:
- Create the Power Browse Form.
- Create a Standard Subform.
- Create a Mapping Link.
- Create a Reusable Subform.
- Using Power Forms System Functions and Event Rules
- Create the Power Edit Form.
- Using Automatic Features of FDA.
- Using the Saved Query Control.
- Creating Grid Icons
- I’ve assumed that you have two tables, linked by UKID. Say the table – 1 is made up of UKID, AN8 and ALPH. The Table – 2 is of UKID, ADD1, CTY, ADDS. Something like the Address Book setup.
- Take a Power EDIT form & insert a subform (reusable or embedded anything would do, depends on your overall architecture). Note: if using resuable subform then take Reusable Edit Subform.
- Attach Header BV to Power form & detail BV to subform. (procedure is similar to any form)
- Check if subform datastructure has UKID in it (To receive subform interconnect values), if not then add (procedure is similar to any form)
- In properties of Power form, select tab “Mapping links”. Check whether proper subform is selected in “Link To” combo box. Assign the respective UKID field/variable of power form which would contain UKID values and needs to be passed to subform. Assign the proper direction i.e. From Power to Subform for this scenario.
- Use system function “Notify Child” to pass control & data to subform. Most probably you would like to use this function in “Post dialog is initialized” event of Power Form.
- Once this function is executed, an event “Notified by Parent” would be invoked in subform.
- Assign Subform interconnect values of UKID to the filter fiield on subform. This would show all the detail records on subform. (If Automatic find on entry property is set on the grid of subform). In our setup this property is somehow not working on subform grid.
- What we do is to have a “Hidden Find” button on subform which is pressed using system function in Notified by parent event.
These were the steps to show detail record(s) corresponding to header.
- Insert a Push button with default functionality of “Save” on subform & Hide it.
- On Power form’s OK button’s appropriate event use system function “Trigger Default Child Action” to press save button of subform. This would save the detail record along with header record. (there are other methods as well)
Please find the Developing Powerform-Based on JD Edwards EnterpriseOne Applications PDF from David Terborg – Please Register to View/Download