Two similar linked records link the BOOKINGS/LICENCES and the COSTS tables with the REPORTS table. I create a new record on the junction REPORT table (primary field = ReportID), and I manually choose to bring which licenses from the BOOKINGS/LICENCES table and which costs from the COSTS table will be included in this particular report from linked record on each tables.
Then I created a linked record both on the BOOKINGS/LICENCES table and on the COSTS tables that automatically pulls into those tables the reportID number (primary field) and an associated lookup field, so I can know directly from the BOOKINGS/LICENCES table, in which report a particular license is included. Same from the COSTS table.
I replicated the same logic and created the same relations through linked records on both tables. It works perfectly on the COSTS table. For a reason I cannot understand and after several attempts it simply does not work on the BOOKINGS/TABLE . Neither the information about the record number (primary field) or the associated filed is pulled into the table.

