I have a fairly simple question, but I’m not sure how to do it in Airtable:
I have a group of students that are completing book reports. I have the “Students” table with a list of all students, and I’m creating a “Book Report” form for them to fill out when they finish a book. When completing their form, I want them to be able to select their name from a Multiple Select list of students in the “Students” table so that their Book Report will be automatically linked to their record. The form is located in the same “Students” table.
How can I create a Multiple Select field on the “Book Report” form which is populated using the Primary ID (student name) on the “Students” table?