create lookup from query

Dynamics 365 for Finance and Operations/AX Developer Forum
#1

i have to create a lookup from the following query

Select OTMaster

Where (OTMaster.EffectiveFromDate <= ITL_admin_MonthlyExp.TransactionDate && OTMaster.EffectiveTodate>= ITL_admin_MonthlyExp.TransactionDate) ||

(OTMaster.EffectiveFromDate <= ITL_admin_MonthlyExp.TransactionDate && OTMaster.EffectiveToDate == datenull());

plz help hw can i do dis !