I'm trying to create a Sheets that defines various objects, and these objects sometimes reference each other (equivalent to SQL foreign key).
Is there a way that I can limit the values of a cell, to only those values that already exist in a range of another sheet?
So say I have a sheet of parents, and a sheet of kids. Each parent is a row in the sheet, and the first column is the name. In the kids sheet, the first column is a name, and the second column is mom. I want mom to be a dropdown of the names that exist in the parents sheet.
How can this be done?