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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.