Record can only be chosen once.? How to do it

801 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

How to disable the selection entry twice in the table.
Let’s say I have a list of equipment. I want to assign it to the classrooms.
One cabinet can have a lot of equipment.
But unique equipment can only be chosen once.

Is it possible and how to do it? Thank YOU.

1 Reply 1

If you have a an [Equipment] table and a [Classroom] table:

Create a view in [Equipment] with a filter that is {Classroom} <is blank>. Set the {Equipment} linked field in the [Classroom] table to only select from that view.