Hi all,
In production control module,
I want to add lookup(RouteId) on route details form this is based on site Id from salesLine and Item mapped to the route version.
After that i want to count the available routes in the lookUp.
Please anyone suggest.
Thanks.
*This post is locked for comments
Hi anyone suggest please.
Hi
How to automatically load the values in grid.
i.e In a lookup i will select one value and load the grid.I didn't select the lookup that is automatically load the first value in the lookup to grid.
You may create a Computed View Columns & implement using systable lookup.
daxmusings.codecrib.com/.../computed-view-columns-in-ax-2012.html
Hi how to find number of available rows in the look up drop down.
You need to find the relation between the tables, which you use in the lookup.
Then you may link the tables in the query, how you want to show in the lookup.
Kindly Make a note that some people, may not work in the very same your requirement.
But the procedure is similar. If you explore your requirement in detail (table structure, AssosiatedLinkBetweenTables, small example), someone might help you.
Hi Krishna
I want routeId only in the look up this is based on siteId and ItemId combination from sales Order Line i.e how to set in queryValue pls response. AnyOne
You can make use of Sysmultitable lookup or views.
Look into below articles give you idea.
community.dynamics.com/.../multi-table-lookups-sysmultitablelookup
hellodax.com/.../lookup-using-view-example-x
https://hellodax.com/2015/02/16/lookup-using-view-example-x/
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
