Reference field error

ericgilmore · ‎03-18-2019

I have a table with 3 reference fields. Two of the fields work as expected. The third however, returns an error whenever I try to use it to search for an entry in it's associated table. I created the tables and reference fields using the same process. I even tried deleting and recreating the field only to run into the same error. Anyone else ever experience this?

v.London

ericgilmore · ‎03-18-2019

I think the link that @Harshinya provided was trying to explain that if you use a Column label/name that's the same as the table you're trying to establish a reference field to, you'll end up with some type of circular reference concerning the field name and table name.

I had a table called Package. Then I created a reference field called Package in another table, and when I attempted to do a lookup using that field on a form I'd get the "null_list.do?" error.

I deleted the reference field and gave it a different name "Not package" and associated it with the Package table again and voila! The lookup using the reference field on the form now works.

View solution in original post

sachin_namjoshi · ‎03-18-2019

IT seems you are creating field in custom scoped app.

IS reference table for third field is in same scope of your custom app? or third field is pointing to table from another scope.

If yes, then you will have to create cross scope privilege access.

https://docs.servicenow.com/bundle/london-application-development/page/build/applications/reference/c_CrossScopePrivilegeRecord.html

Regards,

Sachin

ericgilmore · ‎03-18-2019

@Sachin all the tables actually are accessible from all application scopes. I will dig further though.

Harshinya1 · ‎03-18-2019

Eric,

does the table you are referring to exist?

ericgilmore · ‎03-18-2019

@Harshinya Yes the table does in fact exist.