Auto-Populate a DFF in Requisition Line from Requisition Header DFF
For a Requisition, Header DFF is selected from a ValueSet defined, assume (Yes/No), the same selected value in the Header should be reflected in 'All the Line level DFFs'. And also, there should be a convenience to edit the individual Line's DFF using the same ValueSet.
- I tried creating a new ValueSet using Table - SQL like Query. Multiple values are populated. Help me tweak the Valueset here.
2. I tried implementing an Initial Default value with SQL in the Requisition Line Level DFF and retaining the same Old Valueset (Yes/No) under the Validation.
Query Used: SELECT POR_REQUISITION_HEADERS_ALL.Attribute1 FROM POR_REQUISITION_HEADERS_ALL, por_requisition_lines_all WHERE POR_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID = por_requisition_lines_all.REQUISITION_HEADER_ID.