Answered

lookup based on selection of another field.

(0) Share

Report

Posted on by CU02060633-1

371

i have created one simple form in that i take the site id from the invent site my question is that if i select the site id 1 the another look up show all the site instead of 1..or if i select the site id 2 it show all the site except 2....

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

André Arnaud de Cal... 306,118 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Vinay,

In this case you need to create a custom lookup where you can specify your filters. However you selected the current version, which is D365 for Operations (aka AX7), the documentation from AX2012 should also help you: msdn.microsoft.com/.../hh185372.aspx

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

thanx @André Arnaud de Calavon...in the form from site is the EDT and to site is the string filed i tried to filter on the bases of from site but it not filters

the code is

public void lookup()

{

Query query = new Query();

QueryBuildDataSource queryBuildDataSource;

QueryBuildRange queryBuildRange;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventSite), this);

sysTableLookup.addLookupField(fieldNum(InventSite, siteid));

queryBuildDataSource = query.addDataSource(tableNum(InventSite));

queryBuildRange = queryBuildDataSource.addRange(fieldNum(InventSite, siteid));

queryBuildRange.value(queryValue(AMYinventsiteFromSite.text()));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

the code is doing that if i select the 1 then the to site also showing the 1

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Vinay,

sysTableLookup.addLookupField(fieldNum(InventSite, siteid),true);

Was this reply helpful? Yes No
Verified answer

MUHAMMAD HAARIS 770 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Vinay Tak,

You have given the same site as range, so you get same site in your lookup. If you select the range is not as your selected Site means, you have to give like this

queryBuildRange.value(SysQuery::valueNot(AMYinventsiteFromSite.text()));

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

@Muhammad Haaris ..owsome..this works thans a lottt....can you help me one more thing is that

if i select the from site 1 and to site 2..then ok it saves in table and next time when i select from site 1 to site 2 it throw error record already exist

Was this reply helpful? Yes No
MUHAMMAD HAARIS 770 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Vinay Tak,

Check the index Property in your table whether the InventSiteId added and may be allow duplicates sets true.

Was this reply helpful? Yes No
CU02060633-1 371 on at

Like
a
(0)

Report
Copy link

Link copied!

@Muhammad Haaris...i donot want to use index because from site 1 and to site is 2 then save when the net time user select the from site 2 and to site 2 it throws the error already exist but i have to make validate for the 1 when the from site change it should make the record

Was this reply helpful? Yes No