thanks guys,
but this time I don't want to write a code.
My steps are :
1. Create new EDT
2. in Relation node, I specify table name (PurchTable) and the field.
3. add Related Field Fixed, which is Dimension[5]
..the problem is the value is integer, whereas the value I want to
insert is "TNG".
The purpose is when I use the EDT in DialogField, user can
lookup/search records in PurchTable with Dimension[5] criteria value
is "TNG"
thanks,
--- In Axapta-Knowledge-Village@yahoogroups.com, akash malohatra
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> write the code in the ExecuteQuery() method of the
> datasource to filetr the data with user input value.
>
> declare "QBR" of type Querybuildrange in the class
> declartion.
>
> Then simply pass the userinput value to this
> querybuildrange in the executeQuery() method
>
> QBR.value(queryvalue("the user input")).
>
>
>
> hope this will help you.
> Regards
> Akash
> --- Tony Depalo <[EMAIL PROTECTED]> wrote:
>
> > In AOT/Forms/InventJournalTable there is a drop down
> > box showing ALL,
> > Posted or not Posted then depending on this value
> > the form is filtered,
> > that is maybe show only the posted entries. If this
> > is the sort of
> > functionality you are looking for then follow the
> > logic on this form.
> > Good luck
> > Tony
> >
> > -----Original Message-----
> > From: anton_tjiptadi
> > [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, 18 January 2005 2:40 PM
> > To: Axapta-Knowledge-Village@yahoogroups.com
> > Subject: [Axapta-Knowledge-Village] Lookup table in
> > EDT ?
> >
> >
> >
> > Hi,
> > I want to add lookup table in my EDT which is
> > relate to some
> > table,
> > ex : PurchTable.
> >
> > I want to filter the data to show only some record,
> > for ex :
> > data
> > with Dimension(4) = "TNG"
> >
> > nb : this EDT, I'm gonna use it in Dialog so user
> > can lookup
> > table
> > first to insert the value in that DialogField.
> >
> > Can anyone help me ?
> > thanks in advance,
> > Anton
> >
> >
> >
> >
> >
> > Sharing the knowledge on Axapta.
> >
> >
> >
> > _____
> >
> > Yahoo! Groups Links
> >
> >
> > * To visit your group on the web, go to:
> >
> >
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> >
> > * To unsubscribe from this group, send an email to:
> >
> > [EMAIL PROTECTED]
> >
> <mailto:[EMAIL PROTECTED]
subject=Uns
> > ubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the
> > Yahoo! Terms
> > of Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
