I have a table A, table B and table C. Table A has a one to many relationship with related table B and table C is related to table B through a one to many relationship. This is done to avoid a many to many relationship between table A and B. My issue is as it follows. I want to put in the same form from table A the information of table A + a subgrid made from a view within the relationship between table C and B. The subgrid shows fine in the designer, no issues. However on the page designer it shows up as "Unable to preview" and on the page preview itself it's going to show the form with the basic info fields (text and date fields) but no sub-grid. I have set up permissions with all CRUD operations to both tables to anonymous users for testing and it still does not show up the sub-grid on the form.
Firstly, make sure you've added the subgrid metadata on the form. Secondly, create a Table permission for Table A then add Table B as a Child permission of Table A then add Table C as a Child permission of Table B.
If the above solution doesn't work try removing the form and add it to a test page if subgrid starts displaying make it as your live page. If subgrid still not displaying then delete the form record and configure it again.
cheers
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
12
Share
Report
All responses (
Answers (
