Finance | Project Operations, Human Resources, ...

overridelookup method in form control

(0) Share

Report

Posted on by HRegan

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.

All responses (4)

Answers (0)

Suresh M. Parmar 340 on at

Like (0)

Report

RE: overridelookup method in form control

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
Martin Dráb 232,896 Most Valuable Professional on at

Like (0)

Report

RE: overridelookup method in form control

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.
Suggested answer

Suresh M. Parmar 340 on at

Like (0)

Report

RE: overridelookup method in form control

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.
Suggested answer

Martin Dráb 232,896 Most Valuable Professional on at

Like (0)

Report

RE: overridelookup method in form control

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.