How to create a URL link in email rules to Parent record ID?

The structure of my page consist of 1 main database and 3 sub - databases, all displayed and connected in one view.

I would like to be able to send notification e-mails each time the new record/s are created/ submitted in one of the sub database.

The problem I have is that the {Record ID} takes the record of the sub database instead of the main database and does not work properly.. but the {PAGE URL} seem to work fine; however as a default it re-directs to the edit page instead of the view page required in this case..

I would like to send the link to the main {Record ID} from the sub level, is this possible in Knack?