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

references
(Challa Ramakrishna) #1

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) #2

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?

(Tony Fader) #3

@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 Ramakrishna) #4

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