RE: [development-axapta] Customised Filtering
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
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
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
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
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
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.