There are three tables about user relations:
UserInfo - There are active directory users at this table. User id at Id field and name at name field...
EmplTable - This is firms employee table. Employee code at EmplId field.
SysCompanyUserInfo - This table ties UserInfo and EmplTable tables. UserId field at this table related with Id from UserInfo table, EmplId field at this table related with EmplId at EmplTable. You can call Administrator->User relations form for this relation.
CurUserId() gives you current users ID.
At this sample you created a table and you want to put default users employee id at create new record: MyTable.EmplId = SysCompanyUserInfo::find(CurUserId()).EmplId;
Hiç yorum yok:
Yorum Gönder