Reference field error

[ericgilmore]

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

[Harshinya1]

Can you check this post

https://community.servicenow.com/community?id=community_question&sys_id=93d02cdedb0a93444837f3231f961991

[ericgilmore · Accepted solution]

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.

[Harshinya1]

Glad it helped!