AnsweredAssumed Answered

complex bibliography

Question asked by HinOey on Jan 26, 2017
Latest reply on Jan 27, 2017 by Malcolm

Hello,

 

I am researching a lithographer and collect data regarding books mentioning him and pictures of him in books. I have a file/database with 3 tables (the actual database is more complex).

1. List of all relevant books

2. the table 'mentioning books' registers the books mentioned in a particular book (one record for each book mentioned)

3. for the pictures it is less confusing: all the pictures mentioned in a book.

 

For each of these tables it is no problem getting nice reports. However I want to combine results from all 3 tables in one report.

Attached is relationship for these tables (note that the books table occures twice).

 

What I like to achieve is:

(NB There are books not mentioning other books or pictures; or only books or only pictures)

 

Book-1 (from table Books)

- all the other books mentioned (from table 'mentioning books')

- all the pictures mentioned (from table 'mentioning pictures')

 

Book-2 (from table Books)

- all the other books mentioned (from table 'mentioning books')

- all the pcitures mentioned (from table 'mentioning pictures')

 

Would appreciate suggestions

Attachments

Outcomes