Hi Everyone, I’m new tp Appsheet and trying to build my first app. I have a parent table (Vessels) and a child table (Equipment) . The child table has a ref column (Vessel) to the parent table key (Vessel), the parent table has a virtual column virtual column named Related Equipments, Type = List, Formula = REF_ROWS(“Equipment”, “Vessel”)
The child table (Equipment) in the Google Sheets has 5 rows associated to the parent table. In the parent view, at the end, The parent view only list the first child row out of the 5 rows that are in the table, row 2 to 5 are not listed. If I double checked the Google Sheet file and it has the 5 rows are in the file.
The questions is why is the parent view is not listing all the 5 rows associated with the parent table?
I tried adding a child in the parent view and when I enter the same equipment ID (Key) as one of the exiting rows and hit save, I get an message that the equipment already exist and does add the child to the file.
What am I doing wrong?
I appreciate your response.