Hi Team,
I am new to AX and I got stuck while doing the below operation.
I have a Master Table where I have fields - EmployeeID, EmployeeName, Status(Active/No) and child table (LeaveApp)- LeaveID, EmployeeID (FK)
And I have a form for LeaveApp table in which EmployeeID lookup field should display only Active employees.
Could you please guide me how to write the lookup method on the control EmployeeID on the LeaveApp form?
Thanks.
Hello Martin,
You are right,
In that case, only custom lookup is the option.
For fixed field relation delete action, it will get ignored for inactive status.
Thanks,
Suresh Parmar
I'm not so sure. If you use such a relation, select an active vendor employee and then somebody will make it inactive, the data in the table won't match the relation. Sich records will be ignored by queries using this relation, by delete actions and so on.
Hi,
You need to give the fixed field relation into the LeaveApp table, there is no need to write any custom lookup method.
Follow SS for reference,
Link docs.microsoft.com/.../conditional-table-relations
Thanks,
Suresh Parmar
Please mark verified if get the solution.
Hi, I'm assuming that is just for training, because AX already contains a table for employees (HcmWorker).
As I understand, you didn't use the surrogate key (RecId) for the link - you're using the string field EmployeeId. If so, then overriding lookup(), as you mentioned, is the right approach. Look into documentation to get an idea about how to do it: How to: Add a Lookup Form to a Control.
By the way, please use Development / Customization / SDK category (not Other) for questions related to development. I've already changed it this time.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (