Add a field - Access child table field through parent table reference field

[Patrik Z]

Hello,

I've never thought I'd have to ask a question about forms and fields but here it is

I have a reference field on a form and and need to use that to add a field to the form from a child table field of that reference. To be more specific

• Vulnerable Item Form
  • Vulnerability reference field - referring to [sn_vul_entry], the parent table
    • Need to add a custom date field from [sn_vul_third_party_entry], the child table

How do I access the date field to add it to the form? It's not available in the Form Layout or Form Design. Is there a Dictionary attribute I can add to reference field or something similar?

Thank you for your help

[Musab Rasheed]

Hello,

If custom date field is available on 'sn_vul_entry' table then you can easily add to form by dot walking 'Vulnerability' field. It's simple.

https://www.servicenow.com/community/developer-forum/how-to-define-a-dot-walked-form-field/m-p/26863...

[Patrik Z]

Hello Musab,

Yeah, I thought of that too but we already have that field in the child table and wanted to see if there's another way so that I wouldn't have to create that field anew on the parent table - especially since the other child tables are not going to be using that field at all 🙂

[Musab Rasheed]

You have to create new field, there is no other way to get child fields to parent table other than creating field which will refer to child table then dot walk to child table and add another field on parent, make sure to hide new field for all child tables. It can be done easily.