Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 28, 2021 04:27 AM
Hello there!
So I have a database with several tables:
The last one contains records of compartments in different shelves on different racks. All other tables link to this one to specify where exactly this or that book, journal, etc. is found. All tables contain at least one identical field: Title.
What I need is to create a table that will automatically enumerate unique titles from all tables and show the corresponding locations.
Jun 29, 2021 03:15 AM
instead of having 3 different tables, the best way is to have one table of “items”, with a “category” field (which can be a single-select or link to another table of categories). You can have different views of this table - one for books, one for journals etc.
Jul 13, 2021 04:08 AM
Aye, thanks, figured that out.
Now I’ve run into another problem: apparently some journals have had different names depending on the year of publication, most notably Proceedings of the International Congress of Theoretical and Applied Limnology: some years, its name was in English, sometimes in German, sometimes even in Latin. Is it possible to use multiple titles per record?