I appreciate the help the community to guide me in this! Thanks
Please try below.
In the parent table , please add a reverse reference VC called say โChild Table Form Sliceโ with an expression something like below. The column should be list type with element type as ref.
REF_ROWS(โSlice Name on the child tableThat You wish to base Form Onโ, โParent Table Keyโ)
In the referenced table setting of this column, please select the above slice name ( โSlice Name on the child tableThat You wish to base Form Onโ) .
You wil also have a system created reverse reference column in the parent table with an expression something like
REF_ROWS(โChild Table Nameโ, โParent Table Keyโ)
You could hide is in the parent table form where you wish the slice based child table form to open.
You can go a little deeper, because I tried to follow the instruction but still I donโt understand very well what I have to do and how to make it work.
Assuming your parent table is โOrdersโ and child table is โOrder Detailsโ, please
Create a slice called say โOpen Order Detailsโ on the child table โOrder Detailsโ
Please create a VC in the parent table with name say โRelated Open Order Detailsโ with an expression REF_ROWS(โOpen Order Detailsโ, โOrder Idโ)
The other settings of this column are as below
Please ensure to include this column in the parent table form. Please replace names of parent table (in place of Orders) and child table ( in place of โOrder Detailsโ and slice โOpen Order Detailsโ as you actually have.
There must be something Iโm missing because the ref_row doesnโt appear in the parent form. I show you the step by step of what I did to see what I am missing:
1)This is my parent table and it is referenced by ID_FICHA to the child table that I show in the 2nd image
Below is the child table and its ref to the parent table
Then create Slices for the parent table and for the child table as shown below
Parent Table Slice:
Child Table Slice
To validate that there was no problem, I left all the columns without a filter to avoid errors and then structure everything and rule out any errors.
then create the virtual column as you suggested:
I made sure that it is added in the slice
Create a form view for โOrdenes de Compraโ which is the Slice created from the parent table called โFichaโ
Part 1:
All the columns appear except the referenced one that we created.
Hello @Inventarios_FOODis, iโve reviewed your screenshots, you donโt need a slice/form view combo for the parent table for this to work, only for the child.
On the child table: create the slice and the appropiate form view for that slice
On the parent table: a virtual column referencing the slice of the child table
Yes, but I need the Slice also the parent table because there are several views to have several functions from the same parent table and that is why I should also change the way the child table is displayed
@Suvrutt_Gurjar what do you think?
Thank you for all the details. I think your overall configuration looks okay.
You have created a conditional slice โOrden de Compraโ on the parent table FICHA with row filter condition, [TIPO MOVIMENTO]=โCompraโ . This condition could be an issue.
I think you may want to try first test by including the VC โRelated Ficha_OCโ on the parent table form rather than parent table slice.
Also please take a look at the exactly similar implementation in the sample app below. The โOpen Order Detailsโ slice on child table โOrder Detailsโ and VC โOpen Order Detailsโ in the parent table โOrdersโ are similar implementations as yours. There is a slice โOpen Ordersโ on the parent table as well. Please take a look at show_if on the VC โOpen Order Detailsโ and filter condition of the slice โOpen Order Detailsโ . You are also using a condition on parent table slice , so a similar condition may be needed on the child table slice as well.
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |