Disable repeating fields in linked tables

[user10]

Im made few tables and make “Link to Table” fields, how can i make disabled already choosen field?

[Databaser]

Hi @user10 and welcome to the community!

If you should only choose one of the options 1 time, you could create a view in your source table, with the condition that the linked record field is empty. Then, you can use that view to limit your possibilities in the linked field shown above. That way, you will only see the options that haven’t been linked to already.