I am using AppSheet database.I have a table People and a table Roles. I created a table called PeopleRoles so that I can associate people with roles.PeopleRoles has two reference fields (obviously to People and Roles). However, I also have a Descript...

I have a "People" table (with the usual: name, dob, photo). I also have a Roles table with just the name of the role. Finally, I have a PeopleRoles table that has just two fields: external reference to People and external reference to Roles.I can see...