I am creating an app to maintain a Library of Books by supporting Borrow/Renew functionality. I have 2 tables/sheets : one for Members and other for Library Books.
I have created a “Form” table that has column referencing Member database. For the member to Borrow a Book, i am trying to create another column with reference to “List of Library Books” table. Unfortunately i am not allowed to create a reference to the “List of Library books”
I can retrieve a list from “List of Library Books” but i am not sure how it can be turned as a ref to allow user to select it.