How to link EMPLTABLE to USERINFO table via SQL

(0) Share

Report

Posted on by Clark.Walliser

I'm new to AX, using AX 2009. I wan't to link the Employee table to the user information table, but the usual suspects like ID, RecID and PartyID don't appear to work.

Does anyone have a reference for SQL table linking relationships?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

you can use table SysCompanyUserInfo

this table has UserId and EmplD.

UserId is also the primary key for this table. so for each user you can get if its has an associated employee Id.

Was this reply helpful? Yes No
Clark.Walliser on at

Like (0)

Report

Thank you, Sohaib.

That looks like it will do what I want.

Do you gain this knowledge only through experience, or is there reference documentation available?

I’ve been searching for such documentation for 3 months with no success yet.

Was this reply helpful? Yes No