I am having trouble displaying choices of List Field in Parent table

AM24
Giga Guru

I have a table that extends another table. On the extended table, I have a list field called Relationship, whose choices appear as below.

AM24_0-1715384026062.png

On the parent table, it appears like this:

AM24_2-1715384122713.png

Is there any easy fix to get these choices to show up in the parent table? Thanks.

 

Additional Information about setup:

I did not create Relationship on the parent table. I'm not supposed to create new fields on the parent table. There is a one to one relationship between the tables and I was able to have the relationship field appear on the parent table through form layout.

 

13 REPLIES 13

Hi @AM24,

 

Can you share a screenshot of how the dictionary/field is configured with the choices?

 

Cheers

Hey James, thanks for the response. So this is how the field is set up. It is set up in the child table Table2.

AM24_0-1715545063832.png

I've tried setting up the choices like this:

AM24_1-1715547534912.png

I've also tried setting it like this: 

AM24_2-1715547589544.png

u_table2_ref is the reference field on the parent table (Table1) to Table2 (the child table). There is a one to one relationship between the tables.

Hi @AM24,

 

Okay, I am now a bit confused, maybe I misunderstood your question.

I thought Table 2 extended Table 1 and the relationship field was created on Table 1.

But from your screenshot, it appears that it's created on Table 2 instead.

Does that mean the relationship field on Table 1 is actually dot-walked? i.e. u_table2_ref.u_relationship

 

Can you please elaborate on what you are trying to do here? What is the goal/purpose of this requirement?

 

Cheers

Yeah I probably did a poor job of explaining it.

Yes you are correct. The relationship field on Table 1 is dot-walked. Our company wants to avoid creating fields on Table 1, because of certain issues. That's why almost all new fields, including this one, are created on Table 2. However, Table 1 is still being used for the display. I am able to get the choices to show up on Table 2, but cannot get it to show up on Table 1. I was trying to figure out if there was a way to achieve this. Thanks.

If Table 2 is extended from Table 1, so you can add fields to Table 2 and not Table 1, it will include Table1's fields. But you need to view Table 2 to see the choice field on that table as it doesn't exist on Table 1. Your design seems off if users won't view Table 2. Adding a referenced field on Table 1 to Table2 will allow dot-walking when viewing Table 1. But you don't want to add a field to Table 1. Maybe James has a solution.