We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Custom Table reference another table fields

BrianS344076034
Tera Guru

‎12-11-2023 05:10 PM

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?

0 Helpfuls
  • 2,435 Views
1 REPLY 1

AshishKM
Kilo Patron

‎12-11-2023 05:54 PM - edited ‎12-11-2023 05:55 PM

Hi @BrianS344076034 ,

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
0 Helpfuls