Trying to create a relationship with OR instead of AND, is it possible to do so?
Not in the dialog that you show. There's no option there. But a form of "or" based relationships are possible using a value separated list of values in a match field.
You can define a calculation field (text result) in OSV Contacts as:
List ( Book_author ; work_for_hire )
Then your relationship can be:
Status::authorMatch = OSV Contacts::AuthorList
You can probably come up with a better field name than the one I've used here for this calculation field.
Retrieving data ...