I am using the Qualified table to store Vendor Company Code data. In Company Code qualified lookup one of the field (Reconciliation account) is Lookup hierarchy. I am setting a validation as "IS NOT NULL" to this field (Reconciliation account). But this validation works for only the first record in the qualified look up table. If I add a second record in Qualified lookup table the validation does not run on this second record.
Is there any workaround for the validation to work on all the reocrds of the Qualified Lookup table.