Fetching data from one existing table to another

[t7]

Hi Community, Right now I am working on a story where I have two tables. Where I need to show contents of one column of existing table in another table. How can I do it ? 

For  more clarity - I am taking this example. Suppose there is a field in table named as Product so I need to show that Product field as it is in second table.

[Ian-Fusion3 · Accepted solution]

Are the records linked by a reference field? For example on your second table do you have a Reference field that points to "Product"? Slightly more context might be needed, but it sounds like you'll need one of the Product records on your second table's record. Then you can simply dot walk in the form layout to show it.

[Samaksh Wani · Accepted solution]

Hello @t7 

 you need to create a field on your new 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.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it helpful.

Regards,

Samaksh

[Ian-Fusion3 · Accepted solution]

Are the records linked by a reference field? For example on your second table do you have a Reference field that points to "Product"? Slightly more context might be needed, but it sounds like you'll need one of the Product records on your second table's record. Then you can simply dot walk in the form layout to show it.

[Samaksh Wani · Accepted solution]

Hello @t7 

 you need to create a field on your new 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.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it helpful.

Regards,

Samaksh

[Samaksh Wani · Accepted solution]

Hello @t7 

Plz Mark my Solution as Accept and Give me thumbs up, if you find it helpful.

Regards,

Samaksh