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.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Suresh M. Parmar 340 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suresh M. Parmar 340 on at

Like (0)

Report

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

Was this reply helpful? Yes No