Let’s assume I have two tables in my base: Table 1: Authors and Table 2: Books.
Table 1: Authors is a list of names
Table 2: Books is a list of Title and Author, where Author links to a record in Table 2: Authors
Now I would like to create a field in Table 1: Authors, let’s call it “Bibliography”, that links all the book records that link to this specific author.
How could I do this. without having to link all the book records from the Authors table manually?