http://dynamics-ax.blogspot.com/2006/03/replacing-default-lookup-form.ht
ml
Hopefully this will be of some help to you as well. If I ever need to
lookup anything, then I usually have to create my own custom lookup
form, because the default one's don't display all the correct
information that a user would like to use in order to lookup an item,
for example.
After reading through post your questions, and I or someone will try
their best to answer your questions.
Thanks,
Brandon
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of venkat
raghavan
Sent: Tuesday, April 25, 2006 6:23 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Urgent: Working with lookups in
a form
Hai,
Regarding the Lookup, if u r using Extended data type then there is
no need to write a lookup(provide u don't need a customized lookup).If u
want to create a lookup form just see the InventLookup form under the
Forms node in AOT.
regarding the filtration u can do this using the executeQuery
method(Override) .In that method write query like shown below
Note:
set the auto declartion property to yes for the fieldname(form field)
select Header_table
where
Header_table.fieldname == fieldname(form field).valuestr()
regards,
Venkat
Satish <[EMAIL PROTECTED]> wrote:
Hi guys,
I've created a form. The form is linked to a Header_Table and a
Detail_Table. Now, i try to let the user select a field(which is the
primary key) from the Header_Table using a lookup in my form.
Based on the value of this primary key, i try to display the contents
of the Header_Table in the form's header section, and the contents of
the DetailTable in a grid.
I'm really stuck on 2 counts...
1) Creating and using lookups in Axapta.
2) Pulling data from SQL based on the value input by the user.
If i create lookups using the foreign key relationship in a table,
then the value selected from the lookup is not stored in the new
table upon closing the form. Also, once selected, the other related
fields dont refresh.
I'm new to Axapta, so my query may seem a bit silly... But, i'm
really stuck with this one :(
I would appreciate a little detailed solution... a bit of sample code
would be wonderful :)
Thanx in anticipation.
Regards,
Satish
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small
business finance Business finance consultant Business finance
magazine Business finance schools
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.