How do I create a multiple-lookup table?

Topic Labels: Base design
1209 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello there!

So I have a database with several tables:

  • One contains all books in my library
  • Another one contains all journals
  • Another one contains reports, etc.

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.

2 Replies 2
6 - Interface Innovator
6 - Interface Innovator

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.

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?