Hi Appsheet community, Wish you a very happy ...

[Challa_Ramakris]

Hi Appsheet community, Wish you a very happy new year.

I’ve a question. I’ve two tables and there is a relation.

I’ve a reference field of firttable in second table. And I would like to put a restriction on its selection.

Q: If a value is already selected then it should not appear in the list . What I should do ?

Thanks in advance.

[Steven_Coile]

Your question is vague.

What are the names of the columns involved?

How and where would “a value” have “already been selected”?

In what list should the value not appear?

[tony1]

@Challa_Ramakrishna Take a look at this example: appsheet.com - Distinct value dropdown - Only allow values that haven’t been chosen in dropdown Distinct value dropdown - Only allow values that haven’t been chosen in dropdown appsheet.com

[Challa_Ramakris]

@tony Thanks tony, that’s exactly what I’m looking for.