No Add button for Child table in Parent FORM VIEW

Hi All,

I am having trouble with a “Child” table in “Parent” FORM VIEW.

  • In the “Parent” DETAIL VIEW the “Child” table is visible and you can add entries
  • In the “Parent” FORM VIEW if there are no entries in “Child” table there is no ADD button, the column is just not showing, if there are entries then the “Child” table shows related rows, but still no ADD button, and you cant edit existing child rows, you can open them but its just a detail view
  • All related REF column, etc are showing and searchable and editable

PARENT DETAIL VIEW ABOVE LOOKS NORMAL

PARENT FORM VIEW NOT NORMAL

SHOULD LOOK LIKE THIS

ANY THOUGHTS HERE GUYS?

In the child table, the Ref column that refers to the parent table must have Is a part of? enabled.

This is enabled.

I have a few others refs to the parent for lists etc, I checked these and all of them are not “is part of” I thought maybe if one was that it may be conflicting…

But still not able to edit or add in form view.

I have also check UX system button there are no conditions for ADD or EDIT

1 Like

Screenshots

1 Like

Does the table or slice the rows are a part of allow adds?

Yes they are.

I regenerated the Parent Table a view times, another Related ACCOUNT PAYMENTSs list popped up, I added that to the view and it works voila.

I left the other one in the view, they both have exact same formula, the PAYMENTS tab is one I made by adding virtual column, it worked partially and has the same formula, so not sure why it wasnt responding the same, strange that it didnt generate that refrow much earlier I have regnertaed a few times.

2 Likes

I have no explanation for that. @AleksiAlkio , do you have any insight?

What happens if you change the Ref column to text, save it, then change it back to Ref and let the system to recreate the List virtual column?

3 Likes

Hi @AleksiAlkio I initially made a virtual column to create the list as I was copying the ORDERS app example, it worked partially but without the edit and add function in the form only, after a few column regenerate the system created Related… and when I used this list everything worked as expected. I guess the trick is to use the system generated column?

The system generated virtual Refrows() column is a little bit sensitive and you should keep it as it is. If you delete your own one, change the Ref column type to Text and then back to Ref after the save, does it then work properly?

6 Likes

Yes the system generated related list works as expected without deleting my own one, or changing any column type.

Thank You!!

1 Like

Okay good!

1 Like

You have the magic, sir! Thank you!

1 Like