RE: [development-axapta] Customised Filtering

2004-04-30 Thread kam tt 




Dear Amit and Harry,
Thanks for your prompt answer and sorry for my late
reply as I am a slow learner. 
I've successful it by using sysTableLookup. Below is
my code. 
Thanks again Amit and Harry.
Bye
kamtt 

public void lookup()
{
 Query query = new Query();
 QueryBuildDataSource queryBuildDataSource;
 QueryBuildRange queryBuildRange;
 SysTableLookup sysTableLookup =
SysTableLookup::newParameters(tableNum(custTable),this);
 ;

 sysTableLookup.addLookupfield(fieldNum(custTable,
accountNum));
 sysTableLookup.addLookupfield(fieldNum(custTable,
Name));
 queryBuildDataSource
=query.addDataSource(tableNum(custTable));
 queryBuildRange =
queryBuildDataSource.addRange(fieldNum(custTable,
accountNum));
 queryBuildRange.value(CallerTable_CallerId.text());

 sysTableLookup.parmQuery(query);
 sysTableLookup.performFormLookup();
}


--- Deshpande, Harry [EMAIL PROTECTED]
wrote:
 hi Amit!
 
 Hmmm, I guess adding a new datasource is better than
 adding a new field or
 creating a new look up form, but personally speaking
 I avoid adding a new
 datasource unless its absolutely required. Just my
 way of thinking. no real
 rational behind this.
 
 regards
 
 harry
 
 -Original Message-
 From: Amit Jain [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 28, 2004 6:09 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [development-axapta] Customised
 Filtering
 
 
 Hi Harry
 
 First thing i m not suggesting that Kamtt should
 create another field for
 itemgroup, but from the statement of Kamtt it looks
 like that they are
 already using ItemGroup field in SalesLine table. If
 creation of new field
 is a problem then might be he can create a new
 datasource for ItemGroup and
 then use sysTableLookTable class. but i won't
 suggest creation of new forms
 only for look until and unless it cannot be done
 another way. This is what
 my personal experience says. 
 
 What ur opinion.
 
 
 
 Regards
 
 Amit
 
 
 
 Deshpande, Harry [EMAIL PROTECTED]
 wrote:
 
 hi Amit!
 
 Interesting!
 
 The problem with what you are proposing is ...
 
 Either I have to create a field to hold the value of
 'ItemGroupId' on
 salesLine. This field does not serve any purpose
 after a line has been
 created and violates the 'Normalization' rule for
 the data. It also takes up
 unnecessary disk space.
 
 One can also create just an extended data type field
 on the saleTable form
 (in the sales line grid). However, this means..if i
 specify an item group
 and go to second line to specify a different item
 group the first item group
 changes. This will create confusion for the viewer.
 
 This is why I recommended a different lookup form on
 the ItemId with two
 tabs like the 'location' look up form.
 
 Do let me know if you find some problem with the
 above thinking.
 
 regards
 
 harry
 
 -Original Message-
 From: Amit Jain [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 28, 2004 4:50 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [development-axapta] Customised
 Filtering
 
 
 Hi
 
 For this u must have created a data field for
 itemgroup in the salesline
 form. you can anytime override the lookup method of
 the itemid field in
 SalesLine datasource to control the way look up
 behaves. All you have to do
 is use sysTableLookup Class. Refer Axapta's help for
 this. If you still face
 problem then let me know.
 
 
 Regards
 
 Amit
 
 Deshpande, Harry [EMAIL PROTECTED]
 wrote:
 
 hi
 
 On second thoughts...
 
 It will be better if you could change your look up
 form on the item id to
 the format of the look up form on the field
 warehouse (on salesline). So the
 new lookup with have two tabs. On first tab show
 itemgroup and on second tab
 show related items. this will make things easier.
 
 regards
 
 harry
 
 
 -Original Message-
 From: kamtt [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, April 27, 2004 7:18 PM
 To: [EMAIL PROTECTED]
 Subject: [development-axapta] Customised Filtering
 
 
 Hello,
 I am new for Axapta and I have encounter below
 problem.
 In Sales Line of Sales Order, I would like to select
 an ItemGroup 
 first and then it will automatically filter and
 shows for Item 
 Numbers which are only related to selected
 ItemGroup.
 
 I don't want to jump to Item Number and filter using
 standard. In 
 this way, user need to select ItemGroup first and
 and it will show 
 filtered Item Numbers when he dirll down on Item
 Number field. 
 
 Please advice me how to solve the problem.
 
 Thanks in advance,
 kamtt
 
 
 
 
 
 _ 
 
 Do you Yahoo!?
 Win

http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/hotjobs_mail_signature_

footer_textlink/evt=23983/*http://hotjobs.sweepstakes.yahoo.com/careermakeov
 er a $20,000 Career Makeover at Yahoo! HotJobs 
 
 
 
 _ 
 
 Do you Yahoo!?
 Win

http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/hotjobs_mail_signature_

footer_textlink/evt=23983/*http://hotjobs.sweepstakes.yahoo.com/careermakeov
 er a $20,000 Career Makeover at Yahoo! HotJobs 
 
 _ 
 
 Yahoo! Groups Links
 
 
 * To visit your group

RE: [development-axapta] Customised Filtering

2004-04-28 Thread Deshpande, Harry 





hi

On 
second thoughts...

It 
will be better if you could change your look up form on the item id to the 
format of the look up form on the field warehouse (on salesline). So the new 
lookup with have two tabs. On first tab show itemgroup and on second tab show 
related items. this will make things easier.

regards

harry


  -Original Message-From: kamtt 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 27, 2004 7:18 
  PMTo: [EMAIL PROTECTED]Subject: 
  [development-axapta] Customised FilteringHello,I 
  am new for Axapta and I have encounter below problem.In Sales Line of 
  Sales Order, I would like to select an ItemGroup first and then it will 
  automatically filter and shows for Item Numbers which are only related to 
  selected ItemGroup.I don't want to jump to Item Number and filter 
  using standard. In this way, user need to select ItemGroup first and and 
  it will show filtered Item Numbers when he dirll down on Item Number 
  field. Please advice me how to solve the problem.Thanks in 
  advance,kamtt







Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Customised Filtering

2004-04-28 Thread Amit Jain 



Hi

For this u must have created a data field for itemgroup in the salesline form. you can anytime override the lookup method of the itemid field in SalesLine datasource to control the way look up behaves. All you have to do is use sysTableLookup Class. Refer Axapta's help for this. If you still face problem then let me know.


Regards

Amit"Deshpande, Harry" [EMAIL PROTECTED] wrote:


hi

On second thoughts...

It will be better if you could change your look up form on the item id to the format of the look up form on the field warehouse (on salesline). So the new lookup with have two tabs. On first tab show itemgroup and on second tab show related items. this will make things easier.

regards

harry


-Original Message-From: kamtt [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 27, 2004 7:18 PMTo: [EMAIL PROTECTED]Subject: [development-axapta] Customised FilteringHello,I am new for Axapta and I have encounter below problem.In Sales Line of Sales Order, I would like to select an ItemGroup first and then it will automatically filter and shows for Item Numbers which are only related to selected ItemGroup.I don't want to jump to Item Number and filter using standard. In this way, user need to select ItemGroup first and and it will show filtered Item Numbers when he dirll down on Item Number field. Please advice me how to solve the problem.Thanks in advance,kamtt
		Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs 







Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Customised Filtering

2004-04-28 Thread Amit Jain 



Hi Harry

First thing i m not suggesting that Kamtt should create another field for itemgroup, but from the statement of Kamtt it looks like that they are already using ItemGroup field in SalesLine table.Ifcreation of new field is a problem then might be he cancreate a new datasourcefor ItemGroup and then use sysTableLookTable class. but i won't suggest creation of new forms only for look until and unless it cannot be done another way. This is what my personal experience says. 

What ur opinion.



Regards

Amit

"Deshpande, Harry" [EMAIL PROTECTED] wrote:


hi Amit!

Interesting!

The problem with what you are proposing is ...

Either I have to create a field to hold the value of 'ItemGroupId' on salesLine. This field does not serve any purpose after a line has been created and violates the 'Normalization' rule for the data. It also takes up unnecessary disk space.

One can also create just an extended data type field on the saleTable form (in the sales line grid). However, this means..if i specify an item group and go to second line to specify a different item group the first item group changes. This will create confusion for the viewer.

This is why I recommended a different lookup form on the ItemId with two tabs like the 'location' look up form.

Do let me know if you find some problem with the above thinking.

regards

harry

-Original Message-From: Amit Jain [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 28, 2004 4:50 PMTo: [EMAIL PROTECTED]Subject: RE: [development-axapta] Customised Filtering
Hi

For this u must have created a data field for itemgroup in the salesline form. you can anytime override the lookup method of the itemid field in SalesLine datasource to control the way look up behaves. All you have to do is use sysTableLookup Class. Refer Axapta's help for this. If you still face problem then let me know.


Regards

Amit"Deshpande, Harry" [EMAIL PROTECTED] wrote:


hi

On second thoughts...

It will be better if you could change your look up form on the item id to the format of the look up form on the field warehouse (on salesline). So the new lookup with have two tabs. On first tab show itemgroup and on second tab show related items. this will make things easier.

regards

harry


-Original Message-From: kamtt [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 27, 2004 7:18 PMTo: [EMAIL PROTECTED]Subject: [development-axapta] Customised FilteringHello,I am new for Axapta and I have encounter below problem.In Sales Line of Sales Order, I would like to select an ItemGroup first and then it will automatically filter and shows for Item Numbers which are only related to selected ItemGroup.I don't want to jump to Item Number and filter using standard. In this way, user need to select ItemGroup first and and it will show filtered Item Numbers when he dirll down on Item Number field. Please advice me how to solve the problem.Thanks in advance,kamtt


Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs 
		Do you Yahoo!?Win a $20,000 Career Makeover at Yahoo! HotJobs 







Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Customised Filtering

2004-04-28 Thread Deshpande, Harry 





hi 
Amit!

Hmmm, 
I guess adding a new datasourceis better than adding a new field or 
creating a new look up form,but personally speaking I avoid adding a new 
datasource unless its absolutely required. Just my way of thinking. no real 
rational behind this.

regards

harry

  -Original Message-From: Amit Jain 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 28, 2004 6:09 
  PMTo: [EMAIL PROTECTED]Subject: RE: 
  [development-axapta] Customised Filtering
  Hi Harry
  
  First thing i m not suggesting that Kamtt should create another field for 
  itemgroup, but from the statement of Kamtt it looks like that they are already 
  using ItemGroup field in SalesLine table.Ifcreation of new field 
  is a problem then might be he cancreate a new datasourcefor 
  ItemGroup and then use sysTableLookTable class. but i won't suggest creation 
  of new forms only for look until and unless it cannot be done another way. 
  This is what my personal experience says. 
  
  What ur opinion.
  
  
  
  Regards
  
  Amit
  
  "Deshpande, Harry" 
  [EMAIL PROTECTED] wrote:
  

hi 
Amit!

Interesting!

The problem with what you are proposing is ...

Either I have to create a field to hold the value of 'ItemGroupId' on 
salesLine. This field does not serve any purpose after a line has been 
created and violates the 'Normalization' rule for the data. It also takes up 
unnecessary disk space.

One can also create just an extended data type field on the saleTable 
form (in the sales line grid). However, this means..if i specify an 
item group and go to second line to specify a different item group the first 
item group changes. This will create confusion for the 
viewer.

This is why I recommended a different lookup form on the ItemId with 
two tabs like the 'location' look up form.

Do 
let me know if you find some problem with the above 
thinking.

regards

harry

  -Original Message-From: Amit Jain 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 28, 2004 
  4:50 PMTo: 
  [EMAIL PROTECTED]Subject: RE: 
  [development-axapta] Customised Filtering
  Hi
  
  For this u must have created a data field for itemgroup in the 
  salesline form. you can anytime override the lookup method of the itemid 
  field in SalesLine datasource to control the way look up behaves. All you 
  have to do is use sysTableLookup Class. Refer Axapta's help for this. If 
  you still face problem then let me know.
  
  
  Regards
  
  Amit"Deshpande, Harry" 
  [EMAIL PROTECTED] wrote:
  

hi

On second thoughts...

It will be better if you could change your look up form on the 
item id to the format of the look up form on the field warehouse (on 
salesline). So the new lookup with have two tabs. On first tab show 
itemgroup and on second tab show related items. this will make things 
easier.

regards

harry


  -Original Message-From: kamtt 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, April 27, 2004 7:18 
  PMTo: [EMAIL PROTECTED]Subject: 
  [development-axapta] Customised 
  FilteringHello,I am new for Axapta and I 
  have encounter below problem.In Sales Line of Sales Order, I would 
  like to select an ItemGroup first and then it will automatically 
  filter and shows for Item Numbers which are only related to 
  selected ItemGroup.I don't want to jump to Item Number and 
  filter using standard. In this way, user need to select ItemGroup 
  first and and it will show filtered Item Numbers when he dirll 
  down on Item Number field. Please advice me how to solve the 
  problem.Thanks in 
  advance,kamtt
  
  
  Do you Yahoo!?Win 
  a $20,000 Career Makeover at Yahoo! HotJobs 
  
  
  
  Do you Yahoo!?Win 
  a $20,000 Career Makeover at Yahoo! HotJobs 







Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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 : [development-axapta] Customised Filtering

2004-04-27 Thread Steeve Gilbert 




What you need is a custom lookup. Override lookup method of the ItemId field of the sales line. Search for lookup form in Axapta help and you'll get all the code you need. If you have more questions, feel free to ask.

Steeve... 

-Message d'origine-
De : kamtt [mailto:[EMAIL PROTECTED] 
Envoyé : 27 avril 2004 07:18
À : [EMAIL PROTECTED]
Objet : [development-axapta] Customised Filtering

Hello,
I am new for Axapta and I have encounter below problem.
In Sales Line of Sales Order, I would like to select an ItemGroup 
first and then it will automatically filter and shows for Item 
Numbers which are only related to selected ItemGroup.

I don't want to jump to Item Number and filter using standard. In 
this way, user need to select ItemGroup first and and it will show 
filtered Item Numbers when he dirll down on Item Number field. 
 
Please advice me how to solve the problem.

Thanks in advance,
kamtt




 
Yahoo! Groups Links



 










Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.