Prevent Duplicate Names in two different columns

Hello

I am creating a travel request app, where users can request for travel from the authority in an organization. My form has two columns being [Name] with type Name and another column [Other Travellers] with type Enum List with addition.

The [Name] will be the name of the person who is traveling and [Other Travellers] will have the name of the people traveling with him to the same destination. I am trying to make a filter so that the input in [Name] can not be included in the [Other Travellers] or vice versa. If the same name is entered in [Name]and [Other Travellers], it should throw an error.

Please help me on this.

0 5 376
5 REPLIES 5
Top Labels in this Space