Reference a field from another table

[ZGT]

Hello,

I have the following task 

Repair vendor - reference to u_cmdb_product_model.u_repair_vendor

Create this field on the u_cmdb_product_model table - it doesn't exist yet: Choice list with -none-. Options: <Fideltronik> and <Other> (read only) 

I have created the field on u_cmdb_product_model and now I must reference it on my table u_smi_rma_item but I don't know how to reference it there. Can someone help me ?

Thank you!

[Anshu_Anand_ · Accepted solution]

If you link the u_cmdb_product_model and u_smi_rma_item then you can get the u_repair_vendor on the 

u_smi_rma_item .

So if you create a field on u_smi_rma_item table with:-

name: cmdb product model

reference :  u_cmdb_product_model

This will create a reference field on u_smi_rma_item table and via form layout you can bring any fields from u_cmdb_product_model table to your u_smi_rma_item table.

Example:- on incident form you can see caller id reference field from sys_user. so you can bring all the fields from sys_user to this incident form like bringing user_id to incident form from sys_user:-

So like wise all your product model fields can come into your new table u_smi_rma_item  as per your requirement.

If you find this helpful,please mark answer as correct

[paul_mitchell]

I think I have a similar question to the OP.
I wanna reference a column in another table, not the entire table.
All I can see in the Table Form Design is the ability to reference an entire table. You can then later access all the columns, but I don't want that, I only want to reference a column to begin with.
Is this possible?