i have a table emp_records with many to one relationship with department master which has column id,name,status and system fields
while collecting by form is ok, but when it is bulk uploaded how to verify the status=1 for the department name.
And also how to check the link with other master tables like division is belongs to particular department in form i can set data scope department_id = current_form department_id and status=1 but in import how to validate that