Add a custom field Add a custom field “internal ID” in vendor record and populate the internal id of the corresponding record to it.