SBX - Search With Button

SBX - Forum Post Title

ProjId based Activity number filtering

Microsoft Dynamics AX Forum

ax200nine asked a question on 17 May 2018 7:33 AM
My Badges

Question Status

Suggested Answer

Hi we've a customized table where we are having the fields-'Projid'(having EDT-'ProjId') and 'Activitynumber'(having EDT-'ProjActivityNumber') so when we select the value from 'projid'lookup the field 'Activity number' lookup should display all the related activity numbers for the selected 'projid' .how can we achieve this ?

Reply
SeekerDota responded on 3 Oct 2018 6:15 AM
Suggested Answer

Yes you can link it using this query

while select ProjValEmplProjSetup

       join projTable

           where projTable.ProjId == ProjValEmplProjSetup.Projid

       join  smmActivityParentLinkTable

           where smmActivityParentLinkTable.ParentType == smmActivityParentType::Project

              && smmActivityParentLinkTable.RefRecId == projTable.RecId

       join  smmActivities

           where smmActivities.ActivityNumber == smmActivityParentLinkTable.ActivityNumber.

it provides link between Project Id and the corresponding Activity Number

Reply
SeekerDota responded on 3 Oct 2018 6:15 AM
Suggested Answer

Yes you can link it using this query

while select ProjValEmplProjSetup

       join projTable

           where projTable.ProjId == ProjValEmplProjSetup.Projid

       join  smmActivityParentLinkTable

           where smmActivityParentLinkTable.ParentType == smmActivityParentType::Project

              && smmActivityParentLinkTable.RefRecId == projTable.RecId

       join  smmActivities

           where smmActivities.ActivityNumber == smmActivityParentLinkTable.ActivityNumber.

it provides link between Project Id and the corresponding Activity Number

Reply

SBX - Two Col Forum

SBX - Migrated JS