Allow the capability in VBS validation rule to loop existing records and validate based on other obj

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

MetLife

Description (Required):

In VBS defaulting and validation rules, we have below 2 limitations

• Can't validate attributes based on other objects.
• Can only validate the current object row. Looping through existing records isn't available.

This capability is highly needed to enhance functionality and address critical use cases.

Use Case and Business Need (Required):

There are numerous use cases for these:

Sample use case:

We would like to validate the personal identifier during entry to check if the same type and number already exist by looping through existing records.