Skip to main content
Solved

Cant See Associated Records

  • April 16, 2025
  • 0 replies
  • 173 views

Forum|alt.badge.img+3

Hi i table 1 app - 3 tables, table 1, table 2, table 3

now i have relation of one to many from table 1 to table 3. this relationship is old and has been working fine but suddenly i cant see the associated records from table 3 at the end of the record in table 1. they use to populate properly earlier. i have not changed anything in the relationship, cant understand why getting this error, it says "

sorry...error retreiving data

 Attached the image as well. 

Only thing i can think of is another admin, was asked to delete all the unwanted reports so he may have deleted the associated report from table 3. if yes, how can i recreate the same. ? or any other reason for this problem.

Best answer by SonaAdmin

I had joined the live office hours session and got clarity, used any existing report, so i used list all and it worked fine. Thanks Don. Thanks Sam.

Forum|alt.badge.img+15
  • Registered
  • April 16, 2025

If the embedded report has been deleted, you will have to make it from scratch and then display it.

 


Forum|alt.badge.img+15
  • Registered
  • April 16, 2025

Since you are not seeing the data from Table 3 in your existing form that is where you should build the report.   I would call it Embedded for Table One

Then on the Form for Table One, you reference that report as in the screen capture above.


Forum|alt.badge.img+3
  • Author
  • Registered
  • Answer
  • April 18, 2025

I had joined the live office hours session and got clarity, used any existing report, so i used list all and it worked fine. Thanks Don. Thanks Sam.