Custom Table reference another table fields

Brian Sorensen
Giga 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
  • 1,507 Views
1 REPLY 1

AshishKM
Kilo Patron
Kilo Patron

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

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