Ref not showing in Form View

[Joaquim_Machado]

Hi There

I'm using a the "order capture" to create a new one  , but Reference between the "Order" (Parent) and "order detailed" (child) its not showing in Form View (it appears only on details) view, even though "its a part" its on.

Thanks for your help

[WillowMobileSys]

---

@Joaquim_Machado wrote:

and "order detailed" (child) its not showing in Form View (it appears only on details) view, even though "its a part" its on.

---

Check in your Parent "Order" table that there is a virtual column added named something like [Related Order Details], that it is defined as LIST type and in that column definition the Base Type is defined as Ref to the Order Details Child table. 

You DO NOT need to add this manually!!  It will be added automatically by AppSheet.  If it is not present, then you have not setup the relationship properly and we will need to dig into that configuration deeper.

If that virtual column IS present, then confirm Show setting is checked/set to TRUE.

If all of the above looks good then we will need to know more about your data configurations.  Any Slices involved?  Any filtering configurations that prevent the column from showing?  Etc.

[Joaquim_Machado]

Thank you very much For your reply.

All the virtual columns where automatically created, no problem there.

I do have slices for open orders and complete orders, all columns are included in the slices, so no problem there I would say.

And there's a link/ref already between the "orders" (Parent) table and "order detail" (child) table, when i open a order in the detail view, it shows the referenced "order delails":

But when opening the form it doesn't allow to add new ones:

Also the the column order in UX are set to show all columns.

Any ideas on this?

Thanks again for the help

[WillowMobileSys]

You mentioned "Is part of" is turned on.  Make sure it is on in the correct column.  It should be the Ref column in the Child table that points back to the Parent.

In the example below, the Parent column is on the Child table

If this property is on in the correct column AND since it seems this column is being shown in the Detail View.  then it must be an issue with the columns visibility.

Either there is a Show_If expression hiding the column on the Form view or the column is not actually a column in the column list. 

If your Form is based on a Slice, go to that Slice definition and be sure this column is part of the Slice column list.

Additionally, make certain that when you run your app and inspect the Form View, it is the SAME Form View you are looking at in the Editor View List.  You can confirm this by looking at the bottom of the emulator window.  It shows you which view is being used.  See image.  It is actually a link.  Tap it to go directly to that view and verify the View configuration.

[Joaquim_Machado]

Thanks again for your help, but I can't really get to the bottom of this, i've checked all your advice but nothing. Getting nuts with this one 

[Steve]

Please contact AppSheet Support for help with this.

[aminsaleh]

@Joaquim_Machado 

sorry to step in late, make sure that the child table allows edit and update. 

[BenjaminCarrera]

Check in behavior if your add button is enable