Link the CustTable.MainContactWorker


I need to link the CustTable.MainContactWorker to bring through the worker name from the DirPartyTable.

I’m using Qlik (a BI tool) to load the individual tables and using key fields to link them but cannot find the link between them.

I get stuck when going from CustTable > HCMWorker > ???

AX says the link is DirAddressBookPartyAllView but this is a view not table so no use to me.

Thanks for any help !

CustTable.MainContactWorker = HCMWorker .RecId
HCMWorker .Person = DirPartyTable.RecId

Perfect !!!

Thanks for your help.