I have a “citation” field for my “article” record, an article may refer to several citations, e.g. Book A, p.57 and Book B, p.327.
Obviously I also have a “Books” table with book name and published year, author etc.
But I don’t know how to associate “page number” easily with the selected book. Must I create another table linking Article, Book and page number? This would be the obvious way in traditional database design and you would create a UI to simplify the book/page number selection. However in Airtable it would be a multi-step process for the user: select Citation field, create Add+, select the book, add page number, then close the book-page record, then close again. Could this process be simplified so the user only has to select the book and add page number in one action?