Patrickjk
Active Member
Hello,
I am fairly new to JDE (May of 2016) - JDE OneWorld XE version B7333. I have a Find/Browse form calling a Headless Detail form for "Adding/Updating" records. The data is from a customized table with the Address Number as the primary key.
Issue
When I select a record from the F/B grid and call the H/D form, all records in my F/B grid display in my H/D grid, and I only want to display the selected record from the F/B form.
Resolution?
I added a hidden Business View AN8 form control to the H/D form and set the AN8 form control filter property to "equal". Since this column is AN8, I also did an override of disabling the Default Value, the Next Numbering, and the Visual Assist. the Grid Options on the H/D form has "Automatically Find On Entry" set to true. This fixed the issue, but caused a new issue. The "Add" on the H/D form no longer works. Instead of inserting the grid column/cell Address Number value in the DB table, it's inserting the BV AN8 form control value, which is blank but defaulted to a zero in the DB table.
Is there an easy fix for this, or will I have to create two identical H/D forms - one for the "Add" and the other for the "Update"?
Any help would be greatly appreciated.
Patrick
I am fairly new to JDE (May of 2016) - JDE OneWorld XE version B7333. I have a Find/Browse form calling a Headless Detail form for "Adding/Updating" records. The data is from a customized table with the Address Number as the primary key.
Issue
When I select a record from the F/B grid and call the H/D form, all records in my F/B grid display in my H/D grid, and I only want to display the selected record from the F/B form.
Resolution?
I added a hidden Business View AN8 form control to the H/D form and set the AN8 form control filter property to "equal". Since this column is AN8, I also did an override of disabling the Default Value, the Next Numbering, and the Visual Assist. the Grid Options on the H/D form has "Automatically Find On Entry" set to true. This fixed the issue, but caused a new issue. The "Add" on the H/D form no longer works. Instead of inserting the grid column/cell Address Number value in the DB table, it's inserting the BV AN8 form control value, which is blank but defaulted to a zero in the DB table.
Is there an easy fix for this, or will I have to create two identical H/D forms - one for the "Add" and the other for the "Update"?
Any help would be greatly appreciated.
Patrick