Need help with validity check on array table ASAP - Systems testing for release
On cm3r, user adds optional approvers to approval.name and approval.id arrays. Current validity is checked based on approval.name and works fine. Unfortunately we've found the approval.name is not unique, as there are many SMITHS in the company.
I need to validate on the both the approval.name (full name from operator) and approval.id field (name in operator) for each row in the table.
On validity record:
Field name approval.name
secondary file query condition is true
val query full.name=$vrfield
lookup fields full.name val fields $vrfield
Thanks for any assistance the techies may provide. I'm sure I'm overlooking the obvious.