RE: [Axapta-Knowledge-Village] Lookup table in EDT ?

2005-01-17 Thread Tony Depalo
Title: Message






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 PMTo: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: 
  [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,AntonSharing the knowledge on 
  Axapta. 


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 the Yahoo! Terms of Service.










RE: [Axapta-Knowledge-Village] Lookup table in EDT ?

2005-01-17 Thread akash malohatra

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]
 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 ~-- 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/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/