Skip to main content

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. 

 

 

Hmm, in the screenshot of the Bookings table, the linked field to Reports is completely empty.  Given that in the Reports table the linked field to Bookings is populated properly, these fields should all be filled up 

The only thing I can think of is that there might be two linked fields between the Reports and Bookings tables?  If that’s not the case, I’d suggest deleting the link between Bookings and Reports and recreating it, then testing it on a single record to make sure it populates properly


Hmm, in the screenshot of the Bookings table, the linked field to Reports is completely empty.  Given that in the Reports table the linked field to Bookings is populated properly, these fields should all be filled up 

The only thing I can think of is that there might be two linked fields between the Reports and Bookings tables?  If that’s not the case, I’d suggest deleting the link between Bookings and Reports and recreating it, then testing it on a single record to make sure it populates properly

 

Thanks so much!!!! You were right. As I was testing the table and the linked fields I happened to create several test linked records to the report table that I later on ended putting them un hide. It seems I had left visible the wrong one. Following your advice, I made all linked records visible again and discovered that there was one (the correct one) that was populating the report numbers correctly. Now it is working!!!!!


Reply