Tables and Reference Field

[Phani Pasupulet]

for suppose

I have a table1 with 2 fileds
->tablet Name

->count

I have another table (table 2) with one field
Tablet name (reference fiels) here  I want to select the tablet name from the list of tablets stored in the table 1



my problem is I am getting auto numbers instead of tablet list

Can Any one help me please 

Thanks in advance 

[Dr Atul G- LNG]

Hi @Phani Pasupulet 

Seems you have only 1 field in another table so it display only one. Try to add 1 more field and try.

Please mark this response as correct or helpful or the solution accepted if it assisted you with your question.

Regards
Atul G.
Learn N Grow With Atul G

[Aman Kumar S]

Hi @Phani Pasupulet ,

You can't make table name field as display ince its a reference field and display value has to be a string field.
Instead you can bring the table name field column in the list layout so user can see the column and make correct selection.

You can change the list layout behavior by:

Procedure

1. Navigate to System UI > Views.

2. Search for name = sys_ref_list and open the record.

3. Select the Lists related list.

4. Search for the table for which you want to change the view and open the record.

   This is the table you are referencing.

   Once you open the record, you will see a related list called List Elements. This related list shows the columns that will be displayed on the pop-up view for the reference field.

5. Modify the List layout by either deleting columns or adding new ones by clicking New. 

   If you are creating a new column, you can use the same format as one of the other columns on the view. For example:

   
   
   • Element: Column name
   • Position: Position you want this column to be in relation to the rest
   • List ID: Table

Ref link:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0686318

[ritu_saluja]

Hello @Phani Pasupulet 
Please refer to this article.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0721311

Please mark my answer correct and helpful if it helps you.