Unable to create reference to multiple tables

[prashantabkari (prashant prahalad abkari)]

Hi -

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.

[Marc_Dillon]

@prashantabkari

Unfortunately i am not allowed to create a reference to the “List of Library books”

Why not? Is there some error?

References Between Tables

[prashantabkari (prashant prahalad abkari)]

Its giving an error for some reason.
So i have 2 tables : Members and Books
in another table (which i am using for UX) :

1. I have created a column that references Members, using which a user can select a member.

2. I am trying to create a Virtual column that references Books, so that user can select the book he can Borrow.

2nd one is failing or i can’t create a reference there

[Marc_Dillon]

Virtual columns are not editable by users, so you’d need to add a real column for the 2nd Ref.

[prashantabkari (prashant prahalad abkari)]

Yup. I tried that too. But i throws up error

[prashantabkari (prashant prahalad abkari)]

Alright. Found the issue. Referenced Key was not a Key. Thanks