I am having trouble displaying choices of List Field in Parent table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2024 04:35 PM - edited 05-10-2024 09:07 PM
I have a table that extends another table. On the extended table, I have a list field called Relationship, whose choices appear as below.
On the parent table, it appears like this:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2024 07:53 PM
I mean there is a reference field, which is the u_table2_ref from earlier. So I can access fields and most field types show up properly in Table 1. Its just choices in list fields which don't show up properly, which I just have not been able to figure out.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2024 09:19 PM
Okay, I am not entirely sure what you are trying to achieve.. but since it's a dot-walked field, you would need to have the reference field (i.e. u_relationship) populated first to use the fields from the referenced record. Has this field been populated?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2024 07:39 AM
Yes, the field has been populated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2024 01:51 PM
Hmm, I tried it in my PDI and it seems like you can only modify what is already selected in the referenced record.
There must be a reason why, but unfortunately, I wasn't able to find any document.
Do you have to use the list type field? It works fine with the choice type.