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.
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.
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?