I have a set of data in a table called 'line items' linked to a set of pages in a related table called 'docket' by a linking through the job number. The database works fine and I think this is a standard, fairly basic set up. In dockets I show the records from line items that are associated with the same job number under a single page using a portal.
One record in the docket has lost the links to the related data in line items under one job number. I presume the file has been slightly corrupted but rebuilding doesn't restore the link. I know the data is there as I can find it under all the items in line items. Is there a way that I can manually restore the link?