I am fairly new to Airtable and have adopted a base from someone that i am now trying to set up more efficiently.
There is a large list of items in 1 table (400 entries). In the other table i want the user to select one of these items so i have set the field type to “link to another record” which then references the particular column with the 400 codes.
i only want one record to be chosen / selected per entry
i dont want the user to be able to choose an item which is not on the list and create a new record