Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Custom Table reference another table fields

Brian Sorensen
Giga Guru

So we have a custom table called New Hires

We are basically creating a workspace for our HR team and IT group to align.

Right now HR works out of excel, and its driving me bonkers when I need to reconcile against IT records.

 

In the new table I have a field called Workday Position ID (workday_postion_id) which I also have a Position ID field on the ALM_Hardware table.

 

What I want to do is use the ALM one on the HR table, and have another field - Model Type - that shows what laptop is tied to the ID

 

This is what it looks like on the ALM Table

BrianSorensen_0-1702343287921.png

 

I would assume I want to put in a reference in the New Hire table?

1 REPLY 1

AshishKM
Kilo Patron
Kilo Patron

Hi @Brian Sorensen ,

I don't see any issue in your approach, you can add the column in New Hire table from alm_hardware table with condition matched with assigned_to of alm_hardware table.

AshishKMishra_0-1702346076865.png

-Thanks,

AshishKMishra


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution